LinkBack URL
About LinkBacks
I have 45 columns, each of which have 45 individual cells/items. From each column I need to pick the 5 minimum values to export to another sheet. Can anyone help me with this. Thanks!
I have 45 columns, each of which have 45 individual cells/items. From each column I need to pick the 5 minimum values to export to another sheet. Can anyone help me with this. Thanks!
You can use the SMALL() function to grab the smallest number from a column, or second smallest, etc.
=SMALL(A:A, 1)
=SMALL(A:A, 2)
...etc
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If you want a quick way of doing this -
(I'm assuming your data is in sheet Sheet1, columns A to AS (1 to 45) )
Select another sheet, and type in cell A1
then drag this cell down to A5. Then highlight cells A1:A5 and drag across to AS1:AS5.
Please Login or Register to view this content.
Thanks for the help!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks