有100层的套嵌,但excel2007最多只能套嵌64层,有没有办法突破,或换一种计算方法?
笨笨的方法,数组公式如下:
=IF(B9=$A$1,1, IF(B9=$B$1,2, IF(B9=$C$1,3, IF(B9=$D$1,4, IF(B9=$E$1,5, IF(B9=$F$1,6, IF(B9=$G$1,7, IF(B9=$H$1,8, IF(B9=$I$1,9, IF(B9=$J$1,10, IF(B9=$K$1,11, IF(B9=$L$1,12, IF(B9=$M$1,13, IF(B9=$N$1,14, IF(B9=$O$1,15, IF(B9=$P$1,15, IF(B9=$Q$1,17, IF(B9=$R$1,18, IF(B9=$S$1,19, IF(B9=$T$1,20, IF(B9=$U$1,21, IF(B9=$V$1,22, IF(B9=$W$1,23, IF(B9=$X$1,24, IF(B9=$Y$1,25, IF(B9=$Z$1,26, IF(B9=$AA$1,27, IF(B9=$AB$1,28, IF(B9=$AC$1,29, IF(B9=$AD$1,30, IF(B9=$AE$1,31, IF(B9=$AF$1,32, IF(B9=$AG$1,33, IF(B9=$AH$1,34, IF(B9=$AI$1,35, IF(B9=$AJ$1,36, IF(B9=$AK$1,37, IF(B9=$AL$1,38, IF(B9=$AM$1,39, IF(B9=$AN$1,40, IF(B9=$AO$1,41, IF(B9=$AP$1,42, IF(B9=$AQ$1,43, IF(B9=$AR$1,44, IF(B9=$AS$1,45, IF(B9=$AT$1,46, IF(B9=$AU$1,47, IF(B9=$AV$1,48, IF(B9=$AW$1,49,IF(B9=$AX$1,50,IF(B9=$AY$1,51,IF(B9=$AZ$1,52,IF(B9=$BA$1,53,IF(B9=$BB$1,54,IF(B9=$BC$1,54,IF(B9=$BD$1,55,IF(B9=$BE$1,56,IF(B9=$BF$1,57,IF(B9=$BG$1,58,IF(B9=$BH$1,59,IF(B9=$BI$1,60,IF(B9=$BJ$1,61,IF(B9=$BK$1,62,IF(B9=$BL$1,63,IF(B9=$BM$1,64,"")))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
|