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

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

¦^´_ 10# clio
¤@¡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

Àò±oµª®×ªº¤èª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


    LOOKUP(,0/(MAX(A2:E2)=A2:E2),A$1:E$1) ¾A¥Î©ó°}¦C¸Ì¥u¦³1­Ó0±¡ªp¡A­Y°}¦C²z¦³¦h­Ó0®É¨Ï¥Î LOOKUP(9,0/(MAX(A2:E2)=A2:E2),A$1:E$1) §ä¨ì³Ì«á¤@­Ó0
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# clio


    ·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

¤j³¡¤À»Ý­n°}¦C³B²zªº¤½¦¡»Ý­n°}¦C¤½¦¡¿é¤J¡A
°}¦C³B²z¤¤¦³  IF¡BIFERROR ¤@©w­n¨Ï¥Î°}¦C¤½¦¡¿é¤J
°£ LOOKUP¡BMMULT¡BSUMPRODUCT ¥i¥H³B²z°}¦C¥~¡A¨ä¥¦¤½¦¡¤j³¡¤À»Ý­n°}¦C¤½¦¡

­è¶}©l»Ý­n¸Õ¸Õ¬Ý¤@¯ë¤½¦¡¿é¤J¤Î°}¦C¤½¦¡¿é¤J¨âºØ¡A¤[¤F´N¥i¥H§PÂ_¡A¦³®É§Ú¤]»Ý­n¸Õ¤@¤U¤~¯à½T©w
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# ML089

·PÁÂML089¤j¤jªº¸Ô²Ó¸Ñ»¡¡A§Ú¦A¦h¬ã¨s¬Ý¬Ý¡A³o­ÓÁÙ¬O»Ý­n²ÖÁZ¸gÅç­Èªº¡K·PÁ±z¡C
clio

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD