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)

Postby kasliwalmumbai » Thu Dec 13, 2012 3:25 pm

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)

Please help me.... :oops:

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)

Postby pankaj » Wed Jan 09, 2013 5:09 pm

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


Return to “Excel Tips”



Disclaimer

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to abuse@edupristine.com and we will rectify it.