[µo°Ý] IF¤½¦¡Â²¤Æ°ÝÃD

tsuan

§Ú·Q½Ð±Ð¦U¦ì¥ý¶i:
¥Ø«e§Ú¥ÎExcel »s§@¤@¥÷¤ñ»ùªí¡A§Q¥Îmin() ¨ú±o³Ì§C­È«á¡A¦A¥ÎIF()¨ú±o¬Û¹ï¼t°Ó¦WºÙ¡A¦ý¦]¼t°Ó®a¼Æ±`¦³¥[´î±¡§Î¡A§Úªº¤½¦¡=IF(X3="","",IF(G3=X3,$E$1,IF(J3=X3,$H$1,IF(M3=X3,$K$1,IF(P3=X3,$N$1,IF(S3=X3,$Q$1,$T$1))))))¡A¦p¸I¨ì®a¼Æ¼W´î®É¡A¦Û¤v§ó§ï®É¤]³£¬Ý±o²´ªá¼º¶Ã¡A¤£ª¾¦³¨S§ó¦nªº¤è¦¡?

jimmuLu

¦^´_ 1# tsuan


   ¥Î¤@­Óªí¥h¥]§t©Ò¦³¸ê®Æ¡A´N·|¦³¤j¤j©Ò»¡©±®a¼Æ¶qÅܰʮɡA¨ç¼Æ´N±o§ï±oÀY©ü¸£µÈ¡A

«Øij±N¦U¶µ³f«~¥H¤@­Ó¤u§@ªí¤ñ»ù«á¡A¦A¥HÁ`ªí¥h³sµ²À³¸Ó·|¤ñ¸û²M²n¤@ÂI

tsuan

¦^´_ 2# jimmuLu


    «~¶µ¬O¦³¼Æ¦Êµ§¡A¦]¦¹¤£¯à¥Î³oºØ¤è¦¡³B²z¡C

ANGELA

AE3=IF(X3="","",INDIRECT("r1c"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3,))
°}¦C¤½¦¡

tsuan

¦^´_ 4# ANGELA


   ¤£¬O«Ü²z¸Ñ¡A¥i¥Hµy¥[¸ÑÄÀ¤@¤U¶Ü?

ANGELA

¨º¤@¬q¤£¤F¸Ñ,¥i¥H¥Î¤½¦¡½]®Ö,¬d¬Ý.¥t¥i¥Î·Æ¹«§â½s¿è¦Cªº¨ä¤¤¤@¬q¤½¦¡¤Ï¥Õ,
¦A«öf9§Y¥iª¾¹D¤½¦¡ªºÅܤÆ.

tsuan

¦^´_ 6# ANGELA


    ¦A½Ð°ÝANGELA :
¦A»{¯uºN·j«á¦³µyµy²z¸Ñ¨Ç¤F¡A¦ý°}¦C¤½¦¡§Ú¯uªºÁٻݦh¥[¬ã¨s¤~¦æ¡C¬O§_¥i¥H¦AÀ°§Ú§Ë¥X³Ì§C®É»ù¡B§t¦B²v¤Î±o¼Ð»ùªº°}¦C¤½¦¡©O?
Àµ¨DÀ°¦£¤F!

ANGELA

y3=IF(X3="","",INDIRECT("r1c"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3,))
z3=IF(X3="","",INDIRECT("rc"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3,))
aa3=IF(X3="","",INDIRECT("rc"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3+1,))

tsuan

·PÁª©¥D¡A§Ö¼Ö¨Ï¥Î¤¤¡C
Áö¥i±¤"³Ì§C®É»ù" ¨S¦³¾A·í¤è¦¡¡A¦ý¤w¸g§ïµ½¤Ó¦h¤F

ANGELA

=MIN(IF(N(OFFSET(G3,,(ROW(INDIRECT("$A1:$A"&COUNTA($E$1:$V$1)))-1)*3))=0,9000,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA($E$1:$V$1)))-1)*3))))