[µo°Ý] §ä¥X«ü©w±ø¥ó½d³òªº³Ì¤Ö­È

ricky8751

type        no
A        8
A        2
A        3
B        4
B        5
D        6
C        7
A        1
E        9
A        10
D        11

§ä¥X«ü©w³Ì¤Ö­È?       
A        1
B        4
C        7
D        6
E        9

¨ä¹êª¦¤å«áµo²{¼Ï¯Ã¤ÀªRªí¥i²³æ§ä¥X¨Ó, ¦ý¦pªG·Q¥Î¨ç¼Æ, ¤£ª¾¥i¤£¥i¥H? ¥ýÁÂÁ¤F!

ricky8751

¦^´_ 9# p212


    ¾Ç·|³o­Ó¤F, ÁÂÁÂ

p212

¦^´_ 8# ricky8751
·f°t5#ªº°ÊºA¦WºÙ©w¸q
°}¦C¤½¦¡ =SMALL(IF(x=$D8,y,FALSE),1)¡A¨ÌµM¥i¥H¥¿½T¦a§ä¨ì³Ì¤p­È(­Y¶µ¥Ø¹ïÀ³­È¦³¡u0¡v©Î­t¼ÆªÌ¡A«h¦^À³³Ì¤p­È¬°¡u0¡v©Î­t¼Æ)¡C

ricky8751

¦^´_ 4# p212


    µo²{³o¨ç¼Æ, ¥u¯à§ä¨ì«D 0 ªº³Ì¤p­È? ©_©Ç©_©Ç:dizzy:

ricky8751

·PÁ¨â¦ìªº«ü±Ð¡A­ì¨Ó³o¼Ë²³æ¡A§Ú³ºµM·Q±o³o»ò½ÆÂø¡AÁÂÁÂ

samwang

¦^´_ 4# p212


  ÁÂÁ±zªº«ü±Ð¡AÁÙ¬O¤j¤j·Qªº¤ñ¸û©P¨ì¡A¤½¦¡¬O¤ñ¸û¬¡¥Î

p212

¦^´_ 1# ricky8751
­Y¥DÃDªº¸ê®Æ·|ÀH®É¦V¤U·s¼W¡A«h«Øij±N2#ªº©w¸q¦WºÙ­×§ï¦¨¡u°ÊºA¦WºÙ¡v¡G
x=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A:$A)-1)
y=OFFSET(Sheet1!$B$2,,,COUNTA(Sheet1!$B:$B)-1)
½Ð°Ñ¦Ò¡I

p212

¦^´_ 3# samwang
ÁÂÁÂsamwang¤jªº¥t¸Ñ
«Øij±N¤½¦¡­×§ï¬°
= MIN(IF(($A$2:$A$12=D8)*($B$2:$B$12),$B$2:$B$12,""))
¬O§_¸û¬°¾A¤Á¡H(ªý¤î¦V¤U½Æ»s¤½¦¡³y¦¨°Ñ·Ó½d³òÅܧó)
½Ð°Ñ¦Ò¡I

samwang

E8 °}¦C¤½¦¡
= MIN(IF((A2:A12=D8)*(B2:B12),B2:B12,""))

p212

¦^´_ 1# ricky8751
©w¸q¦WºÙ
x =Sheet1!$A$1:$A$12
y=Sheet1!$B$1:$B$12
Àx¦s®æE8¿é¤J°}¦C¤½¦¡=SMALL(IF(x=$D8,y,FALSE),1)
¦V¤U½Æ»s¤½¦¡§Y¥i¡A½Ð°Ñ¦Ò¡I