求助各位大神： Excel 中将单元格合并后，如何进行排序？

D2=LOOKUP(9E+307,$C$2:C2)/SUM(INDIRECT("B"&SMALL(IF($C$2:C2<>"",ROW($C$2:C2),65536),COUNTIF($C$2:C2,"<>"))): INDIRECT("b"&SMALL(IF($C$2:C10000<>"",ROW($C$2:C10000),65536),COUNTIF($C$2:C2,"<>")+1)-1))*B2
同时按CTRL SHIFT 回车键
再下拉公式

D2 公式：
=LOOKUP(9^9,C$2:C2)*B2/SUM(OFFSET(C$1,LOOKUP(9^9,C$1:C2,ROW(C$1:C2)-1),-1,MIN(IF360问答(C3:C$1000<>"",ROW(C3:C$1000),1+LOOKUP(9^9,B$1:B$1000,ROW(B$1:B$1000)))-LOOKUP(9^9,C$1:C2,ROW(C$1:C2)))))


按Ctrl+Shift+Enter 结束公式
==========================


修改下 ，一样三键 结束：


=LOOKUP(9^9,C$2:C2)*B2/SUM(OFFSET(C$1,LOOKUP(9^9,C$1:C2,ROW(C$1收范这阳台肥府派标:C2)-1),-1,MIN(IF(C3:C$1000<>"",ROW(C3:C$1000),1+LOOKUP(9^9,B$1:B$1000,ROW(B$1:B$1000)))-LOOKUP(9^9,C$1:C2,ROW(C$1:C2)))))