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

[µo°Ý] ¦p¦ó¨Ì¼Ë¦¡§ä¥X³Ì¤j©Î³Ì¤p¤Ø¤o

[µo°Ý] ¦p¦ó¨Ì¼Ë¦¡§ä¥X³Ì¤j©Î³Ì¤p¤Ø¤o

¦p¦ó¨Ì¼Ë¦¡§ä¥X³Ì¤j©Î³Ì¤p¤Ø¤o
excel_max_min.jpg
2019-4-6 13:53
¦³±ø¥óªº³Ì¤j­È.zip (7 KB)
°Ñ¦Ò¸ê®Æ¡G
http://bestdaylong.com

¼Æ¾Ú¦³­°¾­
G2:G3=VLOOKUP(F2,A:B,2,)

H2:H3=LOOKUP(1,0/(F2=A$2:A$9),B$2:B$9)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522

·PÁ±zªºµª®×,­Y¬O¨S¦³±Æ§Ç¬O§_¦³¨ä¥L¸Ñªk¡C
°Ñ¦Ò¸ê®Æ¡G
http://bestdaylong.com

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

½d¨Ò¤Ó¤Ö, ¥u¥H¨â¦ì¼Æ¬°¨Ò~~
G2/°}¦C¤½¦¡:
=INDEX($B:$B,RIGHT(QUARTILE(IF($A$2:$A$19=$F2,LEFT($B$2:$B$19&0,2)/1%%+ROW($2:$19)),4*(G$1=$G$1)),4))

¥k©Ô/¤U©Ô//¤£°£¿ù(¦Û¦æ¥[IFERROR)

TOP

¦^´_ 4# hcm19522


    ÁÂÁÂ..
°Ñ¦Ò¸ê®Æ¡G
http://bestdaylong.com

TOP

¥»©«³Ì«á¥Ñ imingho ©ó 2019-4-9 10:46 ½s¿è

¦^´_ 5# ­ã´£³¡ªL
ª©¥D±z¦n,
      §Úªº¤Ø¤o¡A¦³ªº¥u¦³­^¤å¦r¨S¦³¼Æ¦r¡AÁÙ¦³±ø¥ó·|¦³¤G­Ó¥H¤W¡A¦p¹Ï¡C
excel_20190409.jpg
2019-4-9 10:45

¦h±ø¥ó§ä¤å¦rªº³Ì¤j³Ì¤p­È½d¨Ò.zip (7.27 KB)

°Ñ¦Ò¸ê®Æ¡G
http://bestdaylong.com

TOP

¿ï¾Ü G2:H2
¶K¤W¤½¦¡
=INDEX(B:B,RIGHT(QUARTILE(IF((A$2:A$13=F2)*(C$2:C$13=E2),COUNTIF(B:B,">="&B$2:B$13)*10^6+ROW($2:$13)),{0,4}),3))
°}¦C¤½¦¡(¤TÁä)¿é¤J

¿ï¾Ü G2:H2 ¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# ML089
ÁÂÁÂ.¦¨¥\¤F¡C
°Ñ¦Ò¸ê®Æ¡G
http://bestdaylong.com

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD