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

[µo°Ý] ½Ð°Ý¦p¦ó¥Î¤½¦¡¿z¿ï

[µo°Ý] ½Ð°Ý¦p¦ó¥Î¤½¦¡¿z¿ï

,½Ð°Ý¦p¦ó¥Î¤½¦¡¿z¿ï°µ¥XE1:G7ªºªí®æ©O?

E2=INDEX($A$2:$C$13,MATCH(LARGE($C$2:$C$13,ROW()-1),$C$2:$C$13,0),COLUMN(A1))
¦V¥k¦V¤U©Ô

TOP

¦^´_ 2# oobird

·ÓµÛ¤j¤jªº¤½¦¡·|Åܦ¨, ,¤£ª¾­þ¸Ì¦³¿ù,§Ú¬O·Q§ì¥X¨C¤@¦~«×ªº«e¤T¦W¦¨ÁZ

TOP

¥»©«³Ì«á¥Ñ julieh96590 ©ó 2012-7-1 00:07 ½s¿è

E2=INDEX($A$2C$7,MATCH(LARGE($C$2C$7,ROW()-1),$C$2C$7,0),COLUMN(A1))
¦V¥k¦V¤U©Ô¦ÜG4
E5=INDEX($A$8C$13,MATCH(LARGE($C$8C$13,ROW()-4),$C$8C$13,0),COLUMN(A4))
±qE5¦V¥k¦V¤U©Ô¦ÜG7
julie

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD