求解：excel三列数据排列组合
一楼网友的公式在13,16,19,22,23,25,26的位置出了??題, 只要?⒐叫薷娜缦卤憧?
=IF(ROW()>27,"",INDIRECT("A"&ROUNDUP(ROW()/9,))&INDIRECT("B"&IF(MOD(ROUNDUP(ROW()/3,),3)=0,3,MOD(ROUNDUP(ROW()/3,),3)))&INDIRECT("C"&MOD(ROW()-1,3)+1))
如果要改??xn列?,公式可改成:
=IF(ROW()>Row_n^3,"",INDIRECT("A"&ROUNDUP(ROW()/(Row_n*Row_n),))&INDIRECT("B"...全部
一楼网友的公式在13,16,19,22,23,25,26的位置出了??題, 只要?⒐叫薷娜缦卤憧?
=IF(ROW()>27,"",INDIRECT("A"&ROUNDUP(ROW()/9,))&INDIRECT("B"&IF(MOD(ROUNDUP(ROW()/3,),3)=0,3,MOD(ROUNDUP(ROW()/3,),3)))&INDIRECT("C"&MOD(ROW()-1,3)+1))
如果要改??xn列?,公式可改成:
=IF(ROW()>Row_n^3,"",INDIRECT("A"&ROUNDUP(ROW()/(Row_n*Row_n),))&INDIRECT("B"&IF(MOD(ROUNDUP(ROW()/Row_n,),Row_n)=0,Row_n,MOD(ROUNDUP(ROW()/Row_n,),Row_n)))&INDIRECT("C"&MOD(ROW()-1,Row_n)+1))
?K?ow_n值改成n便可。
收起
