I have at table set up with a column sorted max to min in a column. There
can be more than one entry with the same max value. I need to find the min
and max in other columns based on the max in the first column.

5 80.6 <- max value of interest
5 36.1 <- min value of interest
5 53
4 95.1
4.2 23.4
3 87

The table is bigger and I need to pick out multiple values for the max in
the first column. This function will get the first value of the max in the
first column. It returns the 80.6.

=INDEX(R1C2:R6C2,MATCH(MAX(C1),R1C1:R6C1,0),1)

Thanks for any pointers.