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

[µo°Ý] ¯Z¯Å®È¹C²Î­p¡K(§xÂZ¤w¤[ªº°ÝÃD)

[µo°Ý] ¯Z¯Å®È¹C²Î­p¡K(§xÂZ¤w¤[ªº°ÝÃD)

¥»©«³Ì«á¥Ñ ymes ©ó 2010-10-11 16:30 ½s¿è

·Q½Ð±Ð°ª¤â¡Gªþ¥ó¬O¯Z¯Å®È¹C²¼¿ï¡A½Ð°Ý¶À¦â©³¦â°Ï¶ôÀ³¦p¦ó¤U¤½¦¡¡A¤~¯à¦³¥ªÃä²LÂŦ⪺¤å¦r¥X²{¡H
test.png

test.rar (4.23 KB)

~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

=INDIRECT("r1c"&MAX(($A$2:$D$9=F2)*COLUMN($A$2:$D$9)),0)
ctrl+shift+enter

TOP

=INDIRECT("r1c"&MAX(($A$2D$9=F2)*COLUMN($A$2D$9)),0)
ctrl+shift+enter
oobird µoªí©ó 2010-10-11 15:56



ÁÂÁ¤j¤jªºÀ°¦£¡A¦ý¦n¹³¨S¦¨¥\­C
ªþ¤W­ìexcelÀÉ¡A§Æ±æ¯à¤©¥H¨ó§U¡AÁÂÁÂ
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

2楼ªº¬O数组¤½¦¡.¦b单¤¸®æ输¤J§¹¤½¦¡¦Z,¦b编辑状态¤U,¦P时«ö¦íctrl,shift,enter键°h¥X编辑状态.这时­Ô输¤Jªº¤½¦¡会³Q"{...}"¥]围.

TOP

¦¨¥\¤F¡A¯uªº«ÜÁÂÁ±z
Ä@±z¤@¤Á¶¶¤ß
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦³¤H´£¨Ñ«D°}¦C¤½¦¡¶Ü¡HÅý§Ú¤]¾Ç²ß¤@¤U¡I

TOP

¦^´_ 6# oobird
h2=IF(ISNUMBER(MATCH($F2,A$2:A$9,0)),A$1,IF(ISNUMBER(MATCH($F2,B$2:B$9,0)),B$1,IF(ISNUMBER(MATCH($F2,C$2:C$9,0)),C$1,D$1)))
¤UÏX

TOP

ÁÂÁ¡A³o­Ó¤è¦¡¥i¦æ¡A¦ý¦pÄæ¦ì¸û¦h·|«Ü³Â·Ð¡C
lookup¦³¿ìªk¶Ü¡H

TOP

=INDIRECT("R1C"&SUMPRODUCT(($A$1:$D$9=F2)*(COLUMN($A$1:$D$9))),0)
´¶³q¿é¤Jªk¦ý¹ê½è¤W¤´¬O°}¦C¤½¦¡
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD