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

´M§äÄæ¦ì°Ï¶¡³Ì¤j­Èªº¹ïÀ³Äæ¦ì¦WºÙ

´M§äÄæ¦ì°Ï¶¡³Ì¤j­Èªº¹ïÀ³Äæ¦ì¦WºÙ

¦U¦ì¤j¤j
¤p§Ì¦³¤@­Ó°ÝÃD·Q½Ð±Ð¡A¦p¤U¹ÏA-EÄ椺¹ïÀ³¨C¤@­ÓRow·í§@¤@­Ó¸s²Õ¡A¤ñ¹ï³o¤@­Ó¸s²Õ¤º¼Æ­È³Ì¤jªÌ¡AµM«á©óFÄæ¨q¥X¡A¹ïÀ³ªº¼ÐÀYÄæ¦ì¦WºÙ¡A³o­Ó·Q¤F«Ü¤[¡AÁÙ¬O§ä¤£¥X¤@­Ó¤ñ¸û¦nªº¤èªk¡A¯S§O¨Ó½Ð±Ð¦U¦ì­C½ú¡AÁÙ±æÀ°¦£¡A·PÁ±z¡C

´M§ä³Ì¤j­È.zip (6.16 KB)
clio

=LOOKUP(,0/(MAX(A2:E2)=A2:E2),A$1:E$1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# clio

=INDEX($A$1:$E$1,MATCH(MAX(A2:E2),A2:E2,))

TOP

¦^´_ 2# ML089

·PÁÂML089¤j¤j¡K³o­Ó´N¬O§Ú­nªº¸Ñµª¡K¸U¤À·PÁ±z
clio

TOP

¦^´_ 2# ML089

Hi ML089
¤p§Ì§Ú·Q¦A½Ð°Ý¤@¤U¥ÎLookup¬O§ä¨ì³Ì«á¤@­Ó²Å¦Xªº¦ì¸m¡A¨º§Ú¸ÕµÛ¥ÎIndex ·Q§ä¨ì²Ä¤@µ§¡A¦ý¬O§Úªº¦¡¤l¬OINDEX(A$1:E$1,,MATCH(,0/(A2:E2=MAX(A2:E2)),))¡A§ÚÂI²[¼Æ¶i¥h¬Ý¦³¬Ý¨ìµ²ªG¡A¦ý¬O¹ê»Ú¤Wªº§e²{½T¬O#VALUE!¡A¯à§_¬°¤p§Ì§Ú¸Ñ´b¤@¤U©O¡H·PÁ±z¡C
clio

TOP

¦^´_ 3# p212

·PÁÂp212¤j¤j
©pªº¤èªk¤]¬O¥i¦æªº¡A¤Ó´Î¤F¡A³o­Ó¤èªk¡A¥i¥H§ä¨ì²Ä¤@µ§²Å¦Xªº¸ê®Æ¡A¤Ó·PÁ±z¤F¡A¤p§Ì¤]¦³¥Î³o­Ó¤èªk¼g¡A¦ý¬O¶]¥X¨Ó¦³°ÝÃD¡A¡yINDEX(A$1:E$1,,MATCH(,0/(A2:E2=MAX(A2:E2)),))¡z¤£ª¾¹Dp212¬O§_ª¾¹D¤p§Ì¿ù»~ªº¦a¤è¡A¥i§_¤©¥H«ü¥¿©O¡H·PÁ±z
clio

TOP

¦^´_ 5# clio

=INDEX(A$1:E$1,,MATCH(,0/(A2:E2=MAX(A2:E2)),))
§Aªº¤½¦¡¨S¦³¿ù»~¡A¦ý»Ý­n¥Î°}¦C¤½¦¡¿é¤J¤~¯à¹B¦æ

°}¦C¤½¦¡¿é¤J¨BÆJ
¿ï¾ÜÀx¦s®æ - ±N¤½¦¡Áä¤J(©Î¶K¤W)¤u¨ã¦C½s¿èÄæ - ª`·N!´å¼Ð¤´»Ý°±¯d©ó½s¿èÄæ - ¥ý«öCTRL¤ÎSHIFT¤£©ñ - ¦A«öENTER¤TÁä¤è¦¡¿é¤J¤½¦¡¡A¦¨¥\ªº¸Ü­ì¥ý¤½¦¡¥~·|¦³ {....} ¤j¸ó©·

­Y¥u¦³³æ¦C©Î³æÄæ¡A¤½¦¡¥i¥H§ï¬°¤U¦C¤è¦¡¡C(«Ü·L¤p®t²§)
=INDEX(A$1:E$1,MATCH(,0/(A2:E2=MAX(A2:E2)),))

µù¡GVLOOKUP¡BMATCH¡BLOOKUP³£¯à©¿²¤­pºâ¿ù»~²Õ¼Æ¡A§Q¥Î³o¨Ç¯S©Ê¤½¦¡³]­p®É¬G·NÅý¤£­nªº²£¥Í "­pºâ¿ù»~"¡A´N¯à§Ö³t§ä¨ì§Ú­Ì­nªº­È¡C
¨Ò¦p¡G0/(A2:E2=MAX(A2:E2)) ¬°¦ó­n¥h°£0¡A0/TRUE = 0¡F0/FALSE = #DIV/0! (¿ù»~­È)¡A
{#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,0} ²Ä¤@²Õ°}¦C¥u¦³¤@­Ó0 ¨ä¥¦¬°#DIV/0!¡AMATCH¥Î0¥h§ä´N«Ü©ú½T§ä¨ì³Ì«á¤@­Ó¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089

·PÁÂML089¤j¤jªº¦^ÂСK¤Ó·PÁ±z¤F
clio

TOP

¦^´_ 7# ML089

·PÁÂML089ªº¸Ñ»¡¡A§Ú¥i¥H¦A½Ð±Ð¤@­Ó°ÝÃD¶Ü¡H
§Ú­n«ç»ò§PÂ_¦ó®É­n¥Î°}¦Cªº¤½¦¡¿é¤J©O¡H¦]¬°¹³¡iLOOKUP(,0/(MAX(A2:E2)=A2:E2),A$1:E$1)¡j³o­Ó¦n¹³´N¤£¥Î¡A¦Ó¡iINDEX(A$1:E$1,MATCH(,0/(A2:E2=MAX(A2:E2)),))¡j³o­Ó´N»Ý­n¡A§Ú¤j¬ùª¾¹D¡i0/(A2:E2=MAX(A2:E2)¡j³o­Ó´N¬O°}¦Cªº¹B¥Î¡A¬O¥H³o­Ó¦b¤½¦¡¤ºªº²Ä¤@¼h©Î¬O²Ä¤G¼h¨Ó§@§PÂ_¶Ü¡H
ÁÙ­n³Â·ÐML089¦A¸Ñ»¡¤@¤U¡A·PÁ±z¡C
clio

TOP

¦^´_ 7# ML089

Hi ML089
¤£¦n·N«ä¡A¥Ñ©ó§Ú¬ã¨s¤@¤U¤Sµo²{¤@¨Ç°ÝÃD¡A¦A³Â·Ð±zÀ°§Ú¸Ñµª¤@¤U¡A·PÁ±z¡C
¤@¡B¥Ñ¡iLOOKUP(,0/(MAX(A2:E2)=A2:E2),A$1:E$1)¡j»P¡iINDEX($A$1:$E$1,MATCH(MAX(A2:E2),A2:E2,))¡j¡AÅý§Ú·Q¨ì§âMatch¥N¤JLookup¤º¡A©Ò¥H§Ú¼g¤F¡iLOOKUP(MAX(A2:E2),A2:E2,A$1:E$1)¡j¡A¦ý¬O³o­Ó¥X¨Óªºµ²ªG¤£¤@©w³£¬O¥¿½Tªº¡A§Ú¤S²ÓŪ¤F¤@¤U°Ñ¼Æ­n¨D¡Aµo²{array»Ý­n¬O»¼¼W±Æ§Çªº¡A©Ò¥H§ÚµLªk¥ÎLookup·f°tMatchªº¤èªk¨Ó¨ú±o¡A¥¿½Tªºµª®×¡A¥u¯à¥Î¡iLOOKUP(,0/(MAX(A2:E2)=A2:E2),A$1:E$1)¡j ªº¤èªk¹ï¶Ü¡H
¤G¡B§Ú¤]¦bºô¸ô¤W¬Ý¨ì¤@­Ó¦³Ãö©óLookupªº»¡©ú¬O¡iLOOKUP(1,0/(MAX(A2:E2)=A2:E2),A$1:E$1)¡j¡A²Ä¤@­Ó°Ñ¼Æ1©Î¬O¤j©ó0ªº¥ô¦ó¼Æ¦r¡A¬O¬d¨ì³Ì«á¤@­Ó²Å¦Xªº¸ê®Æ¡A­n¬O¬°0«h¬O¬d¨ì²Å¦Xªº¸ê®Æ¡A¦ý¬O¤£¤@©w¬O³Ì«á¤@­Ó²Å¦Xªº¡A³o¼Ë»¡ªk¬O¥¿½Tªº¶Ü¡H¨º¦b¤½¦¡¤¤¡iLOOKUP(,0/(MAX(A2:E2)=A2:E2),A$1:E$1)¡j¡A¨S¦³¿é¤J«ü©w­È¡A¬O«ü¤j©ó0¡AÁÙ¬O0©O¡H
clio

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD