ªð¦^¦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)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD