“大少”请进，有高手能帮忙吗

crmen

怎么我把AB改成IV就不行了呀，我需要取数到IV列



=IF(COUNTIF($A1AB1,"<>0")<COLUMN(B1),"",INDEX($A1AB1,SMALL(IF($A1AB1<>0,COLUMN($A$1:$AB$1),256),COLUMN(B1))))

改成

=IF(COUNTIF($A1:$IV1,"<>0")<COLUMN(A1),"",INDEX($A1:$IV1,SMALL(IF($A1:$IV1<>0,COLUMN($A$1:$IV$1),256),COLUMN(A1))))

就不能用了，郁闷

大少

呵呵,公式中的256原本就是多余了,改为:

=IF(COUNTIF($A1IV1,"<>0")<COLUMN(A1),"",INDEX($A1IV1,SMALL(IF($A1IV1<>0,COLUMN($A$1:$IV$1)),COLUMN(A1)))

试试