how do I find 2nd highest MAX in a row
 

I need the forumla to find the 2nd highest Max in a row. example:



High OOC CRUISE Talent High Photo Max 1 Max2 SUPREME
0 0 0 0 0 0

how do I find 2nd highest MAX in a row
 

Look in help for LARGE

--


Regards,


Peo Sjoblom

"cruise director" <cruise wrote in
message ...
I need the forumla to find the 2nd highest Max in a row. example:



High OOC CRUISE Talent High Photo Max 1 Max2 SUPREME
0 0 0 0 0 0

how do I find 2nd highest MAX in a row
 

I keep getting formula error or it just shows me the MAX. Is there any easier
solution?

"Peo Sjoblom" wrote:

Look in help for LARGE

--


Regards,


Peo Sjoblom

"cruise director" <cruise wrote in
message ...
I need the forumla to find the 2nd highest Max in a row. example:



High OOC CRUISE Talent High Photo Max 1 Max2 SUPREME
0 0 0 0 0 0

how do I find 2nd highest MAX in a row
 

=LARGE(A1:H1,2)

is the second largest in that range

--


Regards,


Peo Sjoblom

"cruise director" wrote in
message ...
I keep getting formula error or it just shows me the MAX. Is there any
easier
solution?

"Peo Sjoblom" wrote:

Look in help for LARGE

--


Regards,


Peo Sjoblom

"cruise director" <cruise wrote in
message ...
I need the forumla to find the 2nd highest Max in a row. example:



High OOC CRUISE Talent High Photo Max 1 Max2 SUPREME
0 0 0 0 0 0

how do I find 2nd highest MAX in a row
 

Thanks so much! That did fix my problem.

"Peo Sjoblom" wrote:

=LARGE(A1:H1,2)

is the second largest in that range

--


Regards,


Peo Sjoblom

"cruise director" wrote in
message ...
I keep getting formula error or it just shows me the MAX. Is there any
easier
solution?

"Peo Sjoblom" wrote:

Look in help for LARGE

--


Regards,


Peo Sjoblom

"cruise director" <cruise wrote in
message ...
I need the forumla to find the 2nd highest Max in a row. example:



High OOC CRUISE Talent High Photo Max 1 Max2 SUPREME
0 0 0 0 0 0