I have a table consisting of columns containg data and blank cells. For
example:

A B C D E F G H
1 5700
2 5750
3 5800 83% 550 3 .77 -90 62 -16.6
4 5850
5 5900 64% 450 3 .78 -86 68 -12.5
6 5950 71% 415 3 .72 -83 58 -15.8
7 6000
8 6050 52% 304 3 .71 -77 63 -11.6
9 6100

First, I need to extract a range of maximum and minimum percentage
values in column 2 - simple enough via Large and Small (the actual
table is much larger than the illustration)

Next I need to extract their corresponding numbers from the first
column, and all subsequent corresponding values in the remaining
columns.

I've spent around five hours today trying to get beyond extracting
maximum and minimum first values via vlookup and failed.

Whether relevant, I don't know but the appearance (or non-appearance)
of the values is random, dependent on other values being present
(themselves being random).


Any help greatly appreciated. Thank you in advance.

Grant