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

[µo°Ý] ±N¤ñ¤j¤p«áªº¼Æ¦r©M¦PÄ檺¼Æ¦r¶ñ¤J¡C

[µo°Ý] ±N¤ñ¤j¤p«áªº¼Æ¦r©M¦PÄ檺¼Æ¦r¶ñ¤J¡C

´ú¸ÕÀÉ¡J
·s¼W Microsoft Excel ¤u§@ªí.rar (4.59 KB)

»Ý¨D¡J
¥ý±N$B7¡J$AX7ªº³Ì¤j¼Æ¶ñ¤JBF2¡JBJ2¡AµM«á±N¨ä¦b²Ä1¦Cªº¦PÄæ¼Æ¦r¶ñ¤JBF1¡JBJ1¡A¦b±N¨ä¦b²Ä71¦Cªº¦PÄæ¼Æ¦r¶ñ¤JBF3¡JBJ3
¥ý±N$B7¡J$AX7ªº¦¸¤j¼Æ¶ñ¤JBF6¡JBJ6¡AµM«á±N¨ä¦b²Ä1¦Cªº¦PÄæ¼Æ¦r¶ñ¤JBF5¡JBJ5¡A¦b±N¨ä¦b²Ä71¦Cªº¦PÄæ¼Æ¦r¶ñ¤JBF7¡JBJ7
¥ý±N$B7¡J$AX7ªº²Ä¤T¤j¼Æ¶ñ¤JBF10¡JBJ10¡AµM«á±N¨ä¦b²Ä1¦Cªº¦PÄæ¼Æ¦r¶ñ¤JBF9¡JBJ9¡A¦b±N¨ä¦b²Ä71¦Cªº¦PÄæ¼Æ¦r¶ñ¤JBF11¡JBJ11

¨ä¾l.........¦P²zÃþ±À¡C

½Ð°Ý¡JBF¡JBJªº¨ç¼Æ¤½¦¡¡H
ÁÂÁÂÀ°¦£¡I

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-4-9 11:49 ½s¿è

¤£ª¾¹D¨ç¼Æ¯à§_¥i±N­pºâ½d³ò¤ºªº"³Ì¤j¼Æ"¥þ³¡¦C¥X(¦³´X­Ó´N¦C¥X´X­Ó)~µM«á¦A©ì¤Þ¥X²Ä1¦C©M71¦Cªº¦PÄæ¼Æ¦r?
"¦¸¤j¼Æ"¡A"²Ä¤T¤j¼Æ"....¦P²z¡C

¦pªG¨ç¼Æ¤£¯à¸Ñ¨M¡A½Ð§iª¾!
ÁÂÁ¦U¦ìªºÀ°¦£!

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-4-11 10:26 ½s¿è

(¥ý)BF2¥k©Ô{=INDEX(7:7,SMALL(IF(MAX($B7:$AX7)=$B7:$AX7,COLUMN($B:$AX),99),COLUMN(A1)))&""

BF1¥k©Ô{=IF(BF2="","",SMALL(IF($B7:$AX7-BF2=0,$B1:$AX1),COLUMN(A1)))

BF3¥k©Ô{=IF(BF2="","",SMALL(IF($B7:$AX7-BF2=0,$B71:$AX71),COLUMN(A1)))


BF6 ¥k©Ô (²Ä2¤j ;²Ä3¤j-->2§ï3)=INDEX(7:7,SMALL(IF(LARGE(IF(MATCH($B7:$AX7,$B7:$AX7,)=$B1:$AX1,$B7:$AX7),2)=$B7:$AX7,COLUMN($B:$AX),99),COLUMN(A1)))&""

(MAX($B7:$AX7)-->LARGE(IF(MATCH($B7:$AX7,$B7:$AX7,)=$B1:$AX1,$B7:$AX7),2) ©Î2§ï1¬°²Ä1¤j)  ¦¹Àu¥ý ¤W¤U¦P¤W
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# hcm19522
h¤j¤j:±z¦n!
´ú¸Õ¦¨¥\¡AÁÂÁ±zªºÀ°¦£!

½Ð°Ý¤@¤U:
=INDEX(7:7,SMALL(IF(MAX($B7:$AX7)=$B7:$AX7,COLUMN($B:$AX),99),COLUMN(A1)))&""
7:7¬O¤°»ò½d³òªº·N²[?
ÁÂÁ±z!

TOP

¦^´_ 3# hcm19522

h¤j¤j:±z¦n!
ÁA¸Ñ¤F^^
=INDEX(7:7,SMALL(IF(MAX($B7:$AX7)=$B7:$AX7,COLUMN($B:$AX),99),COLUMN(A1)))&""
7:7¬O«ü²Ä7¦C¡C
ÁÂÁ±zªºÀ°¦£©M«ü¾É!!

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD