displaying 1st, 2nd, and 3rd in one cell

  • Thread starter Thread starter Nelson
  • Start date Start date
N

Nelson

I've used the 'large' function to determine the first three largest values in
a set of numbers. Now I would like to display those values in one cell. For
example, I would like to display the top three values as 80, 73, 62.

Any suggestions are appreciated.
 
Concatenate the three formulas. For example...

=LARGE(A1:A10,1)&", "&LARGE(A1:A10,2)&", "&LARGE(A1:A10,3)

Rick
 
Assuming there will *always* be at least 3 numbers in your set of numbers...

A1:A10 numbers

=MAX(A1:A10)&", "&LARGE(A1:A10,2)&", "&LARGE(A1:A10,3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return 1st, 2nd, 3rd largest test values 8
STDEV (1st, 2nd, 3rd) and excluding datapoints 1
how do I format numbers to ordinal i.e. 1st, 2nd etc 9
Max Value in a Row 6
1st, 2nd, 3rd Place etc..... 7
Compare 1st Half & 2nd Half of 2008. 3
Finding 3rd (or 2nd) Sunday in a given year/month 5
Cell reference in formula string displays abbreviated value 2

Back
Top