Seperate WS sort highest to lowest

sebasp

New Member
Joined
Jun 25, 2019
Messages
1
I have a report that has over 1500 data points. On a separate ws, I want to pull in the top 10 values that are highest to least.
how can I do this?
Thanks
 

Scott R

Active Member
Joined
Feb 20, 2002
Messages
426
Use the LARGE() function. Enter the #'s 1 thru 10 in A1:A10. In B1, =LARGE([range on other worksheet],A1) and copy down thru B10.
 

Forum statistics

Threads
1,082,588
Messages
5,366,490
Members
400,895
Latest member
shumcal

Some videos you may like

This Week's Hot Topics

Top