A1=1,A2="",A3="",A4=2,A5=3,A6="",A7=4要在B列中得出B1=1,B2=2,B3=3,B

学习时间:2026-03-31 20:27:56 阅读：427

A1=1,A2="",A3="",A4=2,A5=3,A6="",A7=4要在B列中得出B1=1,B2=2,B3=3,B4=4,就把空白值去除,要用公式

害羞的山水

2026-03-31 20:27:56



B1公式:
=IF(ROW()>COUNT($A$1:$A$999),"",INDEX(A:A,SUMPRODUCT(SMALL(($A$1:$A$999"")*ROW($A$1:$A$999),COUNTBLANK($A$1:$A$999)+ROW(A1)))))