Question about a formula

[Bradley H Callender]

what formula can i use to find the 15 largest numbers in a cell?

 

[bryonwoods30]

you have 15 numbers in one cell? separate by what? Whenever you post questions it is really helpful to give a sample of the data you are working with.

 

[Bradley H Callender]

sorry:

WHat i have is a set of numbers in a range that would be E4:E67 i want a formula that would be able to extract the 15 biggest numbers out of the range and place it into another

 

[bryonwoods30]

you should be able to follow this and work out what you need, it shows how to do 10 instead of 15. should be a good start.

http://www.techrepublic.com/article/find-the-top-10-values-in-an-excel-range-without-sorting/6037835

 

[vaskov17]

to find largest use =LARGE(E4:E67, 1), second largest =LARGE(E4:E67, 2), third largest =LARGE(E4:E67, 3) and so on to 15