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

[µo°Ý] ¸ê®ÆÅçÃÒ¤½¦¡¨D§U

[µo°Ý] ¸ê®ÆÅçÃÒ¤½¦¡¨D§U

¦U¦ì¤j¤j¡A¤p§Ì¥d¦b¸ê®ÆÅçÃÒªº¤½¦¡¡Aªí¤¤A2:B12¬O¸ê®Æ°Ï¡AD2(¸ê®Æ)§Ú¤w¸g³Ð¤F¸ê®ÆÅçÃÒ1~3¡AE2(µ²ªG)¤]¬O­n³Ð¸ê®ÆÅçÃÒ¥B¸òµÛD2(¸ê®Æ)©Ò¿ïªº¼Æ¦r¦C¥XA¦C¬Û¹ïÀ³ªºµ²ªG¡A½Ð°Ý¸Ó¥ÎÔ£¤½¦¡?

¼Ë¥»

Â^¨ú.PNG

¼Ë«~.rar (6.13 KB)

Show Chen

{=INDEX(A:A,SMALL(IF(B$2:B$12=D$2,ROW(B$2:B$12),4^8),ROW(A1)))&""
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


³o¤½¦¡®M¥Î¦bE2¸ê®ÆÅçÃҸ̡A¦³°ÝÃD­C...........
Show Chen

TOP

¦^´_ 3# skyrubys

À³¸Ó­n¤@­Ó»²§UÄæ¦ì
¥¼©R¦W.png
2017-6-20 08:24
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# skyrubys

§Q¥Î2¼Ó©Î4¼Ó¤½¦¡(³o¨Ç¤½¦¡³£¬O°}¦C¤½¦¡¡A­n¥ÎCTRL+SHIFT+ENTER¤T¥ó»ô«ö¤è¦¡¿é¤J¤½¦¡)¡A¦A¥t¥~°Ï°ì¥ý²£¥Í¸ê®ÆÅçÃҩһݭnªº¸ê®Æ¡A
E2ªº¸ê®ÆÅçÃÒ - ²M³æ ¿ï¾Ü¤½¦¡°Ï°ì¸ê®Æ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD