Top 3

[Outline]

Hello,

This should be easy, but I cannot get the max or min command to list the 3 largest nos in a column

10
7
8
18
12
4

I want the result to show 18, 12 and 10


Need the command to list the 3 largest in the column

 

[circledchicken]

Hi,

I think you might want to use the LARGE function:
If you wanted it all displayed in one cell, you might do this:

=LARGE($A$1:$A$6,1)&","&LARGE($A$1:$A$6,2)&","&LARGE($A$1:$A$6,3)

 

[T. Valko]

Hello,

This should be easy, but I cannot get the max or min command to list the 3 largest nos in a column

10
7
8
18
12
4

I want the result to show 18, 12 and 10


Need the command to list the 3 largest in the column

Try this...

Book1
	A	B	C
2	10	_	18
3	7	_	12
4	8	_	10
5	18	_	_
6	12	_	_
7	4	_	_
Sheet1

This formula entered in C2 and copied down as needed:

=LARGE(A$2:A$7,ROWS(C$2:C2))