´M§äÄæ¦ì°Ï¶¡³Ì¤jȪº¹ïÀ³Äæ¦ì¦WºÙ
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 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ªº¸ê®Æ¡An¬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¡AY°}¦C²z¦³¦hÓ0®É¨Ï¥Î LOOKUP(9,0/(MAX(A2:E2)=A2:E2),A$1:E$1) §ä¨ì³Ì«á¤@Ó0 |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 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 ¤@©wn¨Ï¥Î°}¦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¤½¦¡
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 12# ML089
·PÁÂML089¤j¤jªº¸Ô²Ó¸Ñ»¡¡A§Ú¦A¦h¬ã¨s¬Ý¬Ý¡A³oÓÁÙ¬O»Ýn²ÖÁZ¸gÅçȪº¡K·PÁ±z¡C |
|
clio
|
|
|
|
|