| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
displaying 1st, 2nd, and 3rd in one cell
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying 1st, 2nd, and 3rd in one cell
Concatenate the three formulas. For example...
=LARGE(A1:A10,1)&", "&LARGE(A1:A10,2)&", "&LARGE(A1:A10,3) Rick "Nelson" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying 1st, 2nd, and 3rd in one cell
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) -- Biff Microsoft Excel MVP "Nelson" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
displaying 1st, 2nd, and 3rd in one cell
=LARGE(A$1:A$20,1)&", "&LARGE(A$1:A$20,2)&", "&LARGE(A$1:A$20,3)
-- David Biddulph "Nelson" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
| cell text not displaying into next blank cell | Excel Discussion (Misc queries) | |||
| Displaying multiple cell references in 1 cell | Excel Discussion (Misc queries) | |||
| Displaying a cell relative to the position to another cell | Excel Discussion (Misc queries) | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
Linear Mode
