心正意诚身修 发表于 2016-4-8 18:29
=IF(LEFT(B2)="·",PHONETIC(INDIRECT("D"&ROW()&":D"&MIN(IF(LEFT(B3:B99)="·",ROW(A3:A99),9999)))),I ...
您好,不要意思又麻烦您了,您之前的这个函数写的很好,我想问下您有没办法让最后一个带“·”的显示为空?非常期待您的回复。=IF(LEFT(B2)="·",PHONETIC(INDIRECT("D"&ROW()&":D"&MIN(IF(LEFT(B3:B99)="·",ROW(A3:A99),9999)))),IF(F2="","",LOOKUP(1,0/(D$2:D2<>""),$D$2:D2)))
|