Forum Discussion
Solved
finding 3 largest and 3 smallest numbers in a spreadsheet
Hi. Im relatively new to excel formulas. Im trying to pull out the 3 largest and 3 smallest numbers in my spreadsheet. How do I do this/
You can use the LARGE and SMALL functions for this.
To return the 3 largest values in the range A1:Z100:
=LARGE(A1:Z100,{1,2,3})
And the three smallest:
=SMALL(A1:Z100,{1,2,3})
Warning: if there are ties, the results might be unexpected.
You can use the LARGE and SMALL functions for this.
To return the 3 largest values in the range A1:Z100:
=LARGE(A1:Z100,{1,2,3})
And the three smallest:
=SMALL(A1:Z100,{1,2,3})
Warning: if there are ties, the results might be unexpected.
- Thank you so much!!
