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

[µo°Ý] ­×¥¿¤½¦¡¡A¥H§Q¾A¥ÎÅܰʪº¤º®e¡C

¦^´_ 40# Airman

­×¥¿ {=RIGHT(MIN(IF(SMALL(IF(MATCH($B7:$AX7,$B7:$AX7,)=COLUMN($B:$AX)-1,$B7:$AX7),COLUMN(A1))=$B7:$AX7,$B7:$AX7/1%+$B$1:$AX$1)),2)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 41# hcm19522
h¤j:
·PÁ±zªº¦A¦¸¦^À³^^
¤£¦n·N«ä¡AÁÙ¬O¨S¦³²Å¦X»Ý¨D^^"
²³æ»¡´N¬O±N9#ªº¶Q«e3¤jªº¸Ñµª¤½¦¡¡A§ï¬°«e3¤p(§t71¦C¤]¬O¨ú¦PÄæ¹ïÀ³¼Æªº¸û¤pªÌ)¡C
©Î½Ð¸Ô¨£~
http://forum.twbts.com/thread-21687-1-1.html
ÁÂÁ±z^^

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD