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

[µo°Ý] ¡i¨ç¼Æ¡j >1²Õªº¥´"V"¡F=1ªº¥´"X"

¦^´_ 20# hcm19522
h¤j:
±z¤Ó¼F®`¤F!
³£¸Ñ¨M¤F!
A2-->MATCH(A2,D:D,)-1
±z³o¯«¨Ó¤@µ§¡A³sJ¤jªºA2ª¼ÂI¡A¤p§Ì¤]¸Ñ¨M¤F~@~@

ÁÂÁ±zªº¤£§[«ü¾É!
°ª¤â!  b^_^d

TOP

¥»©«³Ì«á¥Ñ joblyc017 ©ó 2017-11-7 20:43 ½s¿è

¦^´_ 21# papaya

­Y¼Ó¥D¤ñ¹ïDÄ欰¥²­n±ø¥ó¡A¤§«e´£¨Ñªº¸Ñªk¡A¤]¬O±NA2´À´«¦¨MATCH(A2,$D:$D,0)-1§Y¥i¹F¦¨

¥t¥~¡A¬°¤FºûÅ@®e©ö¡A±N­ì¥»ªºINDEX¨ç¼Æ§ï¦¨OFFSET¨ç¼Æ¡A
¨Ã­×§ï¦¨¥u­n¸ê®Æµ²ºc¤£ÅÜ¡A¦C¼Æ¤£¶W¹L1001¡A¤£¶·½Õ¾ã¤½¦¡¡A
¶W¹L1001¦C¡A´N½Õ¾ã¤½¦¡¨â³BªºROW($1:$1000)
¡÷¨Ò¡G½Õ¾ã¦¨ROW($1:$2000)¡A¥i¦Û°Ê­p¼Æ¦Ü2001¦C

­×§ï«á¤§§¹¾ã¤½¦¡¡A¸Ô¤U¹Ï¡G

TOP

¦^´_ 22# joblyc017
J¤j:
·PÁ±z¤£§[¦A¦¸«ü¾É!
ÁA¸Ñ¤F!·P®¦^^


«á¨Óµo²{H¶W¯Åª©¥Dªº¤½¦¡¤¤¤w¦³§e²{MATCH($A2,$D$2:$D$8,0)¡A¥u®É·í®É¤p§Ì±Mª`¦b·Q²¤Æ$E$2:$E$8&$F$2:$F$8&....¡A©Ò¥H¨S¦³ª`·N¨ì^^"
¥t¦pªG±N$E$2:$E$8&$F$2:$F$8&....§ï¬°$E$2:$H$8¡F$J$2:$J$8&$K$2:$K$8&......§ï¬°$J$2:$M$8¡F
«hH¶W¯Åª©¥Dªº¤½¦¡¥i§e²{·j´M¥D¼Ðªº°Ï©M¹ïÀ³°Ïªº¥Í¨v¡A¦U²Õ¦Xªº¥Í¨v¥²¶·¬O¥X²{¦b¬Û¹ïÀ³Àx¦s®æªº±ø¥ó¡C

³o¤@ÃD©Ó»X¦U¦ì¥ý¶i¤£§[ªº«ü¾É
¤p§ÌÀò¯q¨}¦h
·P®¦¦A·P®¦.........^^

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD