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

¦p¦ó§ì¥X³Ìªñ¤@¦¸¤é´Á

¦p¦ó§ì¥X³Ìªñ¤@¦¸¤é´Á

¥»©«³Ì«á¥Ñ simon0712 ©ó 2012-10-22 17:59 ½s¿è

¦U¦ìª©¤Í±z¦n¡A¤p§Ì¤£¤~¹ê¦b¤£ª¾¹D¦p¦ó¸Ñ¨M¥H¤U°ÝÃD
¦³¥h·j´Mª©¤Wªº©«¤l¡A¤£¹L¦]¬°Åv­­°ÝÃD¡A¨S¿ìªk¸ü¤Uªþ¥ó¶i¦æ²z¸Ñ¡A
©Ò¥H¥u¦n¨Ó³Â·Ð¦U¦ì¡C


½Ð°Ý¦³¨S¦³¤è¦¡¯à°÷¨C¦¸¶ñ¤J¤é´Á®ÉªºÀx¦s®æ³£¦b¥ª¤è¡A¤]´N¬O¥Ñ¥ª¦Ü¥k¬°³Ì·s¦Ü³Ì¡H
¦]¬°¨C­Ó°Ó«~ªº½LÂI¦¸¼Æ¤£ºÉ¬Û¦P¡A©Ò¥H¦¹Á|¯à°÷¤è«K¶ñ¼g¡AÁÙ¬O»¡¥u¯à±Nªí©Ô¦Ü³Ì¥k¤è¶ñ¼g©O¡H
¥t¥~¡A·Q­n¦bBÄæ¦ì¦Û°ÊÅã¥Ü¸Ó¦C°Ó«~³Ìªñ¤@¦¸½LÂI¤é´ÁÀ³¸Ó«ç»ò°µ¡H

«D±`ÁÂÁ¡C



sample.rar (6.82 KB)

¦^´_ 1# simon0712


    ³Ìªñ¤@¦¸½LÂI¤é´Á
B2=MAX($C47:$F47)
boyao

TOP

B2 :

=MAX($C2:$AZ2)

¤½¦¡¦V¤UÎ`¨î

TOP

«D±`ÁÂÁ¦U¦ìªº¨ó§U¡C

TOP

¤£¦n·N«ä¡A¦A¦¸½Ð±Ð¦U¦ì¡A¦pªG§Ú·Q®Ú¾Ú¤W­zMAX±o¥Xªºµ²ªG¡A
¨ÏB5¶]¥X¸Ó¤é´Á©Ò½LÂI¥Xªº¼Æ¶q¡AÀ³¸Ó«ç»ò°µ©O¡H




sample.rar (7.15 KB)

TOP

¤£¦n·N«ä¡A¦A¦¸½Ð±Ð¦U¦ì¡A¦pªG§Ú·Q®Ú¾Ú¤W­zMAX±o¥Xªºµ²ªG¡A
¨ÏB5¶]¥X¸Ó¤é´Á©Ò½LÂI¥Xªº¼Æ¶q¡AÀ³¸Ó«ç»ò°µ©O¡H ...
simon0712 µoªí©ó 2012-10-22 21:01


B2 :

=LOOKUP(2,1/($C2:$GT2<>""),$C2:$GT2)

¤½¦¡¦V¤UÎ`¨î

TOP

¦^´_ 6# JBY


  «D±`ÁÂÁ±zªºÀ°¦£¡C

TOP

¥»©«³Ì«á¥Ñ simon0712 ©ó 2012-10-23 07:43 ½s¿è

¦U¦ì¦n¡A§Ú«ö·Ó«e­±¼ö¤ßªºªB¤Í´£¨Ñªº¤è¦¡¤w¸g§ä¥X³Ì·s¤é´Áªº¤è¦¡
¦ý¬O¦b¹Á¸Õ§ä¥X·í¤é¼Æ­È®É¡A¨Ì§e²{¿ù»~ªºª¬ºA¡A¥i¥H³Â·Ð¦U¦ì§i¶D¤p§Ì§Ú­þ¸Ì¦³°ÝÃD¶Ü¡H

¡]D5¡BE5¡BF5¥X²{³Ì·s¤@¦¸ÀËÅç¤é´Áªº¼Æ¾Ú¡^

ÁÂÁ¦U¦ì¡I

sample.rar (11.26 KB)

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-10-23 12:42 ½s¿è

¤é´Á¤£­n¥Î¯u¦X¨Ö§ï¬°°²¦X¨Ö¥H«O¯d¨C­ÓÀx¦s®æ³£¦³­È¡C
D5=LOOKUP(2,1/(($H$3:$CA$3=$D$3)*($H$4:$CA$4=D$4)),$H5:$CA5) aa.gif
©Î
D5=OFFSET($D$4,ROW(A1),MATCH("*",$H$4:$CA$4,-1)+COLUMN(A1))  ­Y²Ä¥|¦Cªº­È¨S¶ñ¥þ·|¥X¿ù¡C
©Î
D5=LOOKUP(2,1/($H$4:$CB$4=D$4),$H5:$CB5)

TOP

¶â¡A·PÁª©¤j¸Ñµª¡A¥Ø«e¹Á¸Õ¤¤¡I

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD