ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with SMALL

Tue
Apr 6
2010

Excel formula help. In a list of numbers, is there a formula that will tell me the top 3 numbers?

I have a variety of numbers in a vertical list. Is there a formula to input that will tell me the greatest 3 numbers in the list? And another to tell me the least 3 numbers?


Answer

Just like siti Vi said
use this to get the largest three numbers in cells B2, B3 and B4
=LARGE( A:A, 1)
=LARGE( A:A, 2)
=LARGE( A:A, 3)

But adding the second request

Paste this formula in C2 to get smallest one
=SMALL( A:A, 1)
And this in C3 to get 2nd smallest number
=SMALL( A:A,2)
and this to get 3rd smallest
=SMALL( A:A, 3)

VBAXLMan

Tuesday 4/6/2010 9:09:48 AM

Tags

History