excel 随机提取单元格信息并合并填充到单元格

如果没有第一行的ABCD，D1=INDIRECT("A"&RANDBETWEEN(1,COUNTA(A:A)))&INDIRECT("B"&RANDBETWEEN(1,COUNTA(B:B)))&INDIRECT("C"&RANDBETWEEN(1,COUNTA(C:C)))