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

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

¦^´_ 9# hcm19522
hcm19522¤j¤j:±z¦n!
·PÁ±zªº½ç¥¿!
¥u­nCOLUMN($B:$AX)-1
§ï¦¨
IFERROR(INDEX($1:$1,AZ7+1),"")
¬O¶Ü?
2003ª©§ï¦¨
IF(ISERROR(INDEX($1:$1,AZ7+1)),"",INDEX($1:$1,AZ7+1))
¥i¥H¶Ü?
¤p§Ì¦A¬ã¨s¬Ý¬Ý^^"

TOP

¦^´_ 10# ML089

ML089ª©¤j:±z¦n!
°Ï°ì°}¦C©Î¤å¦r«¬¬Ò¥i¡C
¤p§Ì¦³±N±zªº6#ªº¤½¦¡§ï¬°
=IF(ISERROR(SMALL(IF(MAX(IF(COUNTIF($AY7:AY12,$B$1:$AX$1)=0,$B7:$AX7))=$B7:$AX7,$B$1:$AX$1),{1;2;3;4;5;6})),"",SMALL(IF(MAX(IF(COUNTIF($AY7:AY12,$B$1:$AX$1)=0,$B7:$AX7))=$B7:$AX7,$B$1:$AX$1),{1;2;3;4;5;6}))
    °Ï°ì°}¦C

¦Ü©ó¥D±ø¥ó°Æ±ø¥ó©Ò±oªºµª®×¡A¤p§Ì¦³ªþ¦bBD:BF¨Ñ°Ñ
¦pªG¥Ø«eªº8#½d¨Ò±zÁÙ¤£¯à²M·¡¡A¨SÃö«Y!
¤p§Ì¦A°µ¸Ô²Ó¤@ÂI¨Ã³£¥[¤å¦r»¡©ú¡C
§@¦n«á¦Aªþ¤W¨Ñ°Ñ¡C
ÁÂÁ±z^^

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-4-17 15:02 ½s¿è

¦^´_ 11# Airman


    «D¤]   (³Ìªñ¬°¦ó¦³3¤H´£¦¹°ÝÃD)
(¤è¦¡¤@)­ì¤½¦¡§ï³Ì«á¬õ¦r³¡¤À  ( COLUMN($B:$AX)-1-->$B$1:$AX$1)

(¤è¦¡¤G)­ì¤½¦¡·í»²§U ,¥¿½Tµ²ªG¦a¤è(BD7:BF7) ,¥t¤U²³æ¤½¦¡   ¤U©Ô
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2019-4-17 18:01 ½s¿è

¦^´_ 13# hcm19522
hcm19522¤j¤j:
§Ú·QÀ³¸Ó¬O¦P¼ËÁʶR¼Ö³zApp(³Ìªñ«ÜÉq¡AG. PLAY°Ó©±±Æ¦æ²Ä¤@¦W)¡A¦]¬°¸Ì­±ªºªí®æ¨S¦³²Î­p¡A¥u¯à¥Øµø¤H¤u¤ñ¹ï(§Ú­ì¨Ó´N¬O³o¼Ë¥Î)¡C
ÁÂÁ±zªº«ü¾É!¤p§Ì¦A¸Õ¸Õ¬Ý^^

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2019-4-17 18:10 ½s¿è

¦^´_ 10# ML089
²Ä¤@¦Cªº¹ïÀ³¼Æ_B.rar (39.27 KB)
ML089ª©¥D¡J
©I~½d¨Ò°µ¦n¤F^^
½Ð±z3­Ó¤u§@ªí³£­n¬Ý~¦]¬°©È¹Ï¤å»¡©ú³£©ñ¦b¤@­Ó¤u§@ªí¸Ì·|«Ü²V¶Ã¡A©Ò¥H±N3­Ó±¡ªp¦U©ñ¦b¤£¦Pªº¤u§@ªí¡C
PS:
3­Ó¤u§@ªíªº²Ä7¦C,14¦C,.....,63¦C,69¦Cªº¼ÒÀÀ¼Æ¦r¤£¥þ¦P¡FBD¡JBF¦³¥¿½Tªºµª®×¨Ñ°Ñ¡C
¬°¨D²©ú¡A¥uÁ|¬Y¤@­Ó±Æ¦W¥u¦³2­Ó¦P¦WªÌ¡A¤]³\¤]¦³¬Y2­Ó±Æ¦W©Î¬Y3­Ó±Æ¦W¡A¨ä¤¤©Î¦³3­Ó©Î4­Ó.....¦P¦WªÌ¡C
¥H¤W  ÂԨѰѦÒ!ÁÂÁ±z^^

TOP

AZ7:AZ12
=TEXT(SMALL(IF(LARGE($B7:$AX7+$B$71:$AX$71%%,1+COUNTIF($B7:$AX7,">="&INDEX(7:7,MATCH(--AY7,$1:$1,))))=$B7:$AX7+$B$71:$AX$71%%,$B$1:$AX$1,99),{1;2;3;4;5;6}),"[<>99];;")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

²Ä¤@¦Cªº¹ïÀ³¼Æ_Bx.rar (41.01 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 13# hcm19522
hcm19522¤j¤j¡J±ß¦w!
¨þ~¨þ~¬O¤p§Ì·Q¤Ó¦h¤F~
¤@ª½¥ÎINDEX©MMATCH¨ç¼Æ¥h§ïCOLUMN($B:$AX)-1¡A§Ë¤F¤@¤Ñ¡A³£¤£¬O¥¿¸Ñ¡A
­ì¨Óª½±µ±NCOLUMN($B:$AX)-1§ï¬° $B$1:$AX$1§Y¥i¡C
©Ç¤£±oµo°ÝªÌ¨S¦³´£¥X¨Ó¡AÀ³¸Ó¬O¥L¦Û¤v¤w¸g§ï¦n¤F!¯u¦½ÃC^^///

´ú¸Õ§¹¦¨¦p»Ý¨D~
Á±zªº¤£§[«ü¾É!·P®¦^^

PS¡J
±zªº´X­Ó¬ÛÃþ¦üªº¦^µªÃD¤¤¡A¤p§Ì¦³Ãöª`¨ì³o¤@ÃD©M http://forum.twbts.com/thread-21664-1-1.html¡A
¦]¬°³o¤GÃDªº²Î­p½d³ò³£«Ü¤j¡A«o­n¯à¤@¦¡§¹¦¨¡A¹êÄݤ£©ö¡A©Ò¥H¯S§OÂ^¨ú³o¤@ÃD¨Óµo°Ý©MÀ³¥Î¡C
«áÃD¦]¬°ÁÙ¨S¦³¬Ý¨ì§¹¦¨»Ý¨Dªºµ²ªG¡A©Ò¥HÁÙ¦bÃöª`¤¤~«Ü´Á«Ý±zªº¤j§@^^
³Ìªñ§Ú³£ºÉ¶q¥Î»²§UÄæ¡A±N½ÆÂøªº¤½¦¡©î¸Ñ¦¨¦Û¤v·|¼gªºÂ²³æ¤½¦¡¡A¤£µM¦Ñ¬Oµo°Ý¡A¤]¤£¬O¿ìªk¡C

TOP

¦^´_ 17# ML089
ML089ª©¤j¡J±ß¦w!
´ú¸Õ§¹¦¨¦p»Ý¨D~
ÁÂÁ±zªº¤£§[«ü¾É! ·P®¦^^

TOP

¦^´_ 13# hcm19522
hcm19522¤j¤j¡J
½Ð°Ý¡J¶Q¤½¦¡¦p¦ó§ï¬°«e¤T¤p?
±NMAX§ï¬°MIN¡FLARGE§ï¬°SMALLµª®×¤£¹ï^^"

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD