Excel中在第一行输入第一个集合,从A1开始,每个单元格输入1个数,在第二行输入第二个集合,从A2开始,每个单元格输入1个数,A3输入公式=IF(ROW()-2>COUNT($1:$1)*COUNT($2:$2),"",OFFSET($A$1,,ROUNDUP(ROW(A1)/(COUNT($2:$2)),0)-1)&"X"&OFFSET($A$2,,MOD(ROW(A1)-1,(COUNT($2:$2))))&"="&OFFSET($A$1,,ROUNDUP(ROW(A1)/(COUNT($2:$2)),0)-1)*OFFSET($A$2,,MOD(ROW(A1)-1,(COUNT($2:$2)))))往下一直拉即可...
|