- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 32¦ì¤¸
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-6-10
- ³Ì«áµn¿ý
- 2015-6-11
|
[µo°Ý] ½Ð±Ð¸ê®Æ§ì¨ú¨Ã¥BÄæ¦CÂà´«§e²{
½Ð°Ý¦U¦ì«e½ú °ª¤H
n±N¤w±Æ§Çªº¨âÄæ¸ê®Æ(¦pªþ¥ó
datatest01.rar (8.54 KB)
)
name ¦³«½Æ
Sheet1
name phone
A 0911123456
A 0911123457
B 0911123458
B 0911123459
B 0911123460
C 0911123461
C 0911123462
¦bSheet2¤¤ Åܦ¨name«á±ªºphone¦b¦P¤@¦C¤¤Åã¥Ü (¤ñ¹ï¸ê®Æ§ì¨ú«á Äæ¦CÂà´«§e²{¥X¨Ó)
Sheet2
name phone
A 0911123456 0911123457
B 0911123458 0911123459 0911123460
C 0911123461 0911123462
¤p§Ì¦b150µ§¸ê®Æ¤¤ ¸Õ¤FIF index match COUNTIF...¥Î¤F¤@¾ã¤Ñ³£µLªk¦¨¥\
¤gªk·Ò¿ûÁÙ¤ñ¼g¥X¨Óªº¨ç¼Æ»yªk§Ö.........
½Ð°Ý¦U¦ì«e½ú °ª¤â
³o¼Ëªº±¡ªp¥Î¤°»ò¨ç¼Æ¤~¾A¦X¡H»yªk¸Ó«ç»ò¼g©O¡H
ªþ¥ó
datatest01.rar (8.54 KB)
·PÁ½ç±Ð
Orz |
|