Thread: searching
View Single Post
  #1   Report Post  
Tracy A
 
Posts: n/a
Default searching

I have two columns. I want to search the first column for the largest number
and return the value in the next cell.

Then I would like to search the first column for the second largest number
and return the value in the next cell.

I would like to do this without sorting the data!!

Is this possible?