排序 空白不参與 (14368)

E2=IF(C2>0,SUMPRODUCT((C$2:C$16="V")*(B$2:B$16>B2))+1,"")

F2=IF(C2>0,SUMPRODUCT((C$2:C$16="V")*(B$2:B$16<B2))+1,"")

G2=IF(C2>0,COUNTIF(C:C,"<>")-E2,"")