ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¥X²{´Á¼Æ

[µo°Ý] ¥X²{´Á¼Æ

¥X²{´Á¼Æ.rar (4.92 KB)

L2¡JM2ªº¤½¦¡»Ý¨D¡J
=KÄ檺49­Ó¸¹½X¦U¥X²{¦bB¡JHªº³Ì«á3­Ó¦ì¸mªºAÄæ´Á¼Æ¡C

½Ð°Ý¡J
L2¡JM2ªº¨ç¼Æ¤½¦¡­n¦p¦ó½s¼g?
½Ð¦U¦ì¤j¤j½ç±Ð!ÁÂÁÂ!

¤£¦n·N«ä¡Aµ§»~§ó¥¿:
KÄ檺49­Ó¸¹½X.......
­×¥¿¬°
JÄ檺49­Ó¸¹½X.......
ÁÂÁÂ!

TOP

=LARGE(IF($B$2:$H$101=$J2,ROW($B$1:$H$100)),COLUMN(A1))
°}¦C¤½¦¡

TOP

¦^´_ 3# ANGELA

´ú¸Õ«á¡Aµª®×¦p»Ý¨D¡A
ÁÂÁª©¥D¤£§[«ü¾É!·P®¦^^

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD