View Single Post
  #5   Report Post  
Keith
 
Posts: n/a
Default

Thank you very much!

"JE McGimpsey" wrote:

One way:

=LARGE(A:A,2)

In article ,
"Keith" wrote:

I am attempting to do inventory analsysis where I need to pick the highest
and second highest values from a row of numbers. I can get the highest by
using the MAX function....how do I get the second highest number?