如题所述
å¯ä»¥å©ç¨æ°ç»å ¬å¼ï¼
=VLOOKUP(ROW(A1)&D6,IF({1,0},COUNTIF(INDIRECT("A1:A"&ROW($A$1:$A$5)),D6)&$A$1:$A$5,$B$1:B$5),2,0)
å¦ä¸å¾æ示ï¼