• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To filter Largest and Smallest Percentage

Techtrend

Member
Want to filter top 5 and
Botton 5 in % in terms from A Col
and related Symbols and Populate
it in E-F Col

Details are mentioned in the attached document,
Can you please help me to fix.

Thanks In Advance
Narendra
 

Attachments

  • High Low Filter.xls
    36 KB · Views: 5
Hi,

Try this in E2
=LARGE($A$2:$A$212,ROW(A1))

in F2:
=VLOOKUP(E2,$A$2:$B$212,2,0)

E8:
=SMALL($A$2:$A$212,ROW(A1))

F8:
=VLOOKUP(E8,$A$2:$B$212,2,0)

Regards,
 
Back
Top