- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 96
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- OFFICE 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-8-29
- ³Ì«áµn¿ý
- 2023-10-30
|
PJChen¤j¤j§A¦n,
½Ð·Q±Ð.. ¬°¦ó·|¥Î MATCH(B5,B:B,2)?
§Ú¥uª¾¹Dmatch ¥i¥H¥Î -1, 0 , 1...
¦ý¤£©ú¥Õ¥Î2¬O¬°¤°»ò©O?
½Ð±Ð¦U¦ì¤j¤jÀ°¦£¸Ñµª..
^^
¦^´_ PJChen
¸Õ¬Ý¬Ý
E5=IF(COUNTIF(B:B,B5)=1,B5,IF(ROW()=MATCH(B5,B:B,2),B5,""))
¤½ ...
owen06 µoªí©ó 2014-11-28 12:29 |
|