For the cell below
=Offset(A1,Match(Large(A:A,1),A:A,0),0)
=Offset(A1,Match(Large(A:A,2),A:A,0),0)
for the cell to the Right
=Offset(A1,Match(Large(A:A,1),A:A,0)-1,1)
=Offset(A1,Match(Large(A:A,2),A:A,0)-1,1)
If the first and second numbers are equal, then this will give the wrong
answer.
--
Regards,
Tom Ogilvy
"Tracy A" <Tracy
wrote in message
...
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?