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

Ãö©ó°}¦C¨D³Ì¤pª÷ÃB»P¼t°Ó

Ãö©ó°}¦C¨D³Ì¤pª÷ÃB»P¼t°Ó

²×©ó¥i¥Hµo©«¤F»¡....
·Q½Ð°Ý¤j¤j§ÚªºÀɮצ³¤@­Ó»Ý­n§ä´M¤å¨ã¶µ¦¸¤¤³Ì¤pª÷ÃB»P¼t°Ó¦W
¨Ï¥Î°}¦C©MMATCH¤ÎOFFSET
¦ý¬O­YMATCH¹J¨ì­«½Æ¡ã¡ã´N¨Sªk§PÂ_¤F¡ã¡ã¡ã
¼t°Ó©Mª÷ÃB§ìªº¦ì¸m´N·|¬O²Ä¤@­Ó
¤£ª¾¹D¦³¿ìªk¥i¥H§ï»ò¡H¡H¡H
½Ð¨D¤j¤j­Ìªº¨ó§U.....
·P®¦....

111.jpg (46.96 KB)

111.jpg

¸s²Õ³Ì¤pª÷ÃB»P¼t°Ó.ZIP (9.5 KB)

¦^´_ 1# dodo234


    ½Ð¸Ôªþ¥ó

Book1.zip (6.93 KB)

TOP

¥k©Ô ¤U©Ô {=INDEX(B:B,RIGHT(MIN(IF($A$2:$A$13=$E2,$B$2:$B$13*10^4+ROW(B$2:B$13))),3))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# KCC
·PÁÂKCC¤jªº¨ó§U~~~
±zªº¤½¦¡Â²¤Æ«Ü¦h©O.....¶W·P®¦
¦]¬°¤½¦¡¤¤³o³¡¤À§Ú¬Ý±o¤£¬O«Ü¤F¸ÑLOOKUP(1,0/((A$2:A$13=E2)*(B$2:B$13=F2))
¤£ª¾³o±ø¤½¦¡ªº·N«ä¬O???
Àµ½Ð¤j¤j¦A¦¸À°¦£....
ÁÂÁ¤j¤j

TOP

¦^´_  KCC
·PÁÂKCC¤jªº¨ó§U~~~
±zªº¤½¦¡Â²¤Æ«Ü¦h©O.....¶W·P®¦
¦]¬°¤½¦¡¤¤³o³¡¤À§Ú¬Ý±o¤£¬O«Ü¤F¸ÑLOOKU ...
dodo234 µoªí©ó 2017-5-18 13:13

³o­Óºâ¬O³Ì±`¥Îªº¬d¸ß¤âªk¤§¤@
lookup(1,0/((A)*(B)),row())
¤¤¶¡ªº 0/((A)*(B)) ¡A¦P®É²Å¦Xa¡Bb±ø¥óªÌ¬°¬Û­¼¬°1¡A¨ä¾l¬°0 ¡A0/((A)*(B))·|§Î¦¨ ¦h­Ó#DIV/0!©M1­Ó 0 ²Õ¦¨ªº°}¦C¡A¥i¥H³æ±ø¥ó©Î¦h±ø¥ó¹B¥Î
µM«á§ä¥X¤p©ó©Îµ¥©ó1©Ò¦b¦ì¸m¡A¦A¨ú¥X«á­±row()¹ïÀ³ªº¼Æ¦r
§Úµ¹¥Ü¨Ò¬O¦³¥ý¨D¥X¨CºØ«~¶µªº³Ì§C»ù¦ì¡A¤~¥Î³oºØ¤½¦¡
§A¤]¥i¥H°Ñ¦Òhcm¥Sµ¹ªº¡A¨º¤]¬O±`¥Îªº¤âªk¤§¤@¡Aª½±µ¤@¦¡¨ì©³
¥t¥~¡A¦pªG§A·|¥Î¼Ï¯Ã¤ÀªR¡A©Ô¤@©Ô¡A¿z¿ï¤@¤U¡AÀ³¸Ó¤]«Ü®e©ö±o¨ì©Ò­nªºªF¦è

TOP

ÁÂÁ¨â¦ì¤j¤j´£¨Ñªº¤½¦¡......
§Ú¨Ó¦n¦n¬ã¨s¬ã¨s~~~~~
§Ú¤Ó¹à¤F.....
«D±`·P¿E¨â¦ì¤j¤jªºÀ°¦£~~~~~

TOP

F2 °}¦C¤½¦¡¥k©Ô¤Î¤U©Ô
{=INDEX(B:B,-MOD(SMALL(IF($A$2A$13=$E2,$B$2B$13*10^5-ROW($213)),1),-1000))}

2 ¼Ó KCC  ¥S¤½¦¡
G2
=IF(E2="","",LOOKUP(2,1/(($A$2A$13=$E2)*($B$2B$13=F2)),$C$2C$13))
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD