|
楼主 |
发表于 2015-7-4 17:53
|
显示全部楼层
thinkersky 发表于 2015-7-4 16:37
=IF(COUNTIF($A$2:$AB$500,"已售")26,CHAR(INT(--RIGHT(SMALL(($A$2:$AB$500"已售")/1%%%+ROW($2:$500)/1%% ...
您好,我下载您的文件后,仅仅改动一个字,就出现这样的错务。请问大神如何破呢?
=IF(COUNTIF($A$2:$AB$500,"售")<ROW(A1),"",IF(--RIGHT(SMALL(($A$2:$AB$500<>"售")/1%%%+ROW($2:$500)/1%%+COLUMN(A:AB),ROW(A1)),4)>26,CHAR(INT(--RIGHT(SMALL(($A$2:$AB$500<>"售")/1%%%+ROW($2:$500)/1%%+COLUMN(A:AB),ROW(A1)),4)/26)+64),"")&CHAR(MOD(--RIGHT(SMALL(($A$2:$AB$500<>"售")/1%%%+ROW($2:$500)/1%%+COLUMN(A:AB),ROW(A1)),4)-1,26)+65)&INT(SMALL(($A$2:$AB$500<>"售")/1%%%+ROW($2:$500)/1%%+COLUMN(A:AB),ROW(A1))/10000))
|
|