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

¸ê®Æ»`´M°ÝÃD

¸ê®Æ»`´M°ÝÃD

ªþ¥ó¤¤¦³¤@­ÓÀÉ®×
1.§Ú­n¥ý§ä10ÀY¨Å¶q³Ì§Cªº
=SMALL(B$2:B$21,ROW(1:1)) ³o­Ó¥i¥H¸Ñ¨M
2. §Ú­n§PÂ_¹w²£´Á
=VLOOKUP(SMALL(B$2:B$21,ROW(1:1)),¨Å¶q,2,FALSE)
¥H¤W°ÝÃD¨Ó¤F¡A°²³]¨Å¶q¦³2ÀY¬Û¦P¡A¥L¥u·|·j´M¨ì²Ä1ÀYªº¸ê®Æ¡A½Ð°Ý«ç»ò¸Ñ¨M©O

test.rar (8.1 KB)

{=INDEX(C:C,RIGHT(SMALL(B$2:B$21/1%+ROW(B$2:B$21),F4),2))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522

=INDEX(C:C,RIGHT(SMALL(B$2:B$21/1%+ROW(B$2:B$21),F5),2))


    ¤j¤j¡A¦¨¥\¤F¡A¦ý¥i¥HÀ°§Ú¸ÑÄÀ¥y¤lªº¥Îªk¶Ü?
=INDEX(ªí®æ½d³ò,¦C¯Á¤Þ­È,¦æ¯Á¤Þ­È)
¬°¦ó°t¦XRIGHTªº¥Î·N?

SMALL¬O±q¤p§ì¨ì¤j ¡A¦ý¸Ì­±ªº/1% ¬O¤°»ò·N«ä©O? ¡AÀ³¸Ó¬O»¡B$2:B$21/1%+ROW(B$2:B$21 ³o¤@¾ã¬qªº¥Î·N
³Ì«á¨º­Ó2¥Nªíªº·N«ä¬O?

±Ð±Ð§Ú³o­Ó·s¤â§a

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2018-5-31 11:33 ½s¿è

/1% »P*100¬Û¦P
B$2:B$21/1%+ROW(B$2:B$21)-->¦¹¬q¬°*100+¦C¸¹-->¤jªÌ«í¤j ,¼Æ¶q¬Û¦P¦C¸¹¥ç¥i°Ï§O   ,¤À¤j¤p«á¨ú«á­±¤G¼Æ¦r ,¥ç¦C¸¹  -->INDEX(~ , ¦C¸¹) ,¨ú©Ò»Ý­È     ;­Y¼Æ¾Ú¸Uµ§»Ý*10^5  ,RIGHT(~,5)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD