- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-14
|
¥»©«³Ì«á¥Ñ 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 |
|