## Please provide me help on excel (Urgent)

kasliwalmumbai
Posts: 2
Joined: Tue Oct 09, 2012 6:09 pm

### Please provide me help on excel (Urgent)

I have a particular range on numbers, say for example 1 to 10
I want to have such formula such that, i can get top 3 numbers i.e Maximum 3 numbers, i.e result would be 10, 9, 8....

I can not use sort or Filter because the population which i am having . on that its very difficult to apply sort or Filter....
So i want one excel formula which if applies give me the best 3(i.e maximum 3 numbers)

Thanks a lot to Pristine Team for same

Saurabh kasliwal
9892088322

Tags:

pankaj
Finance Junkie
Posts: 61
Joined: Fri Aug 03, 2012 11:24 am

### Please provide me help on excel (Urgent)

Say the data is in column A and the range is 1, 2, 3, 4, ........, 20.
Now you need highest three numbers out of it?
the formula will be:
=LARGE(A1:A20,3)&", "&LARGE(A1:A20,2)&", "&LARGE(A1:A20,1)
or =LARGE(A1:A20,1)&", "&LARGE(A1:A20,2)&", "&LARGE(A1:A20,3)
the result will be = 20, 19, 18 or 18, 19, 20
Hope you understand the formula.............its very simple!!!! :d