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

学习时间:2026-10-10 06:28:48 阅读：4250

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

壮观的钢笔

2026-10-10 06:28:48



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)))))