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

学习时间:2026-06-04 07:00:27 阅读：8111

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

标致的猎豹

2026-06-04 07:00:27



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