- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¦^´_ 5# ã´£³¡ªL
ÁÂÁª©¥D¤j¤jªºSheet1¸Ñµª
¤½¦¡µª®×²Å¦X»Ý¨D¡CÁÂÁ±z^^
¤£¦n·N«ä¡A¤â°Ê¶ñ¤J¡Aº|§ï¤F
E8=45¤~¹ï
§Ú¥ÎSheet1
D2=IF(ISNA(MATCH(A2,C:C,)),"",INDEX(B:B,MATCH(A2,C:C,)))
E2=INDEX(B:B,MAX(IF($C$2:$C$65536=A2,ROW($2:$65536),"")))&"" °}¦C
´N¬O¨S¦³¿ìªk±N"·í¦CAÄæÈ=CÄæÈ"®ÉªºBÄæÈ"¤£pºâ"¦b¤º^^"
ª©¥D¤j¤j:
ÁÙ¦³Sheet2ªºD2©ME2¤½¦¡¡A¥i§_½Ð±z¦A¦¸«ü¾É
ÁÂÁ±z^^ |
|