- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2025-1-2
  
|
¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-10 16:06 ½s¿è
¦^´_ 4# JBY
没·Q¨ì¬õ¦r³¡¥÷¥i¦p¦¹¹B¥Î¡A»s³yMATCHªºlookup_array¡C
=INDEX($C:$C,MATCH(SMALL(IF($A:$A=$G2,$B:$B),COLUMN(A:A)),IF($A:$A=$G2,$B:$B),))
·PÁ¸Ѵb¡I
µù¡GÁô½ª¤½¦¡§ä¤£¨ìªºµ²ªG#NUM!¡A±N¤§Åã¥Ü¬°¡uªÅ¥Õ¡v¡A°}¦C¤½¦¡¡G
=IFERROR(INDEX($C:$C,MATCH(SMALL(IF($A:$A=$G2,$B:$B),COLUMN(A:A)),IF($A:$A=$G2,$B:$B),)),"")
½Ð°Ñ¦Ò¡I |
|