Rotor  Mode  Gauge 1    Gauge 2    Gauge 3
0          1             1            4            4
0          2             6            5            5
0          3             8            4            7
0          4             8            6            8
1          1             7            5            7
1          2             9            4            8
2          1             8            5            9
2          2             5            4            1
2          3             5            8            5

I have the above table in a spreadsheet. The first column shows the
rotor stage. For each rotor stage there are a number of modes of
vibration indicated in the second column. Each stage has gauges in
three positions, these positions have different allowable strains for a
given mode, on a given rotor stage, and these are indicated in the
3rd-5th columns. So for instance for rotor stage 2 vibrating at mode 1
the allowable strain at gauge position 3 is 9.

In another sheet (in the same book) I have this spreadsheet:
Rotor    0

Mode      Gauge      Highest recorded strain  
1                  1                      7
2                      6
3                      5

2                  3                      9
2                      8
1                      6

3                  2                      8
1                      7
3                      1

This table is for rotor stage 0, there are also separate spreadsheets
for the other rotor stages that follow the same format. So I have found
the highest recorded strain at each gauge position for a given mode of
vibration. So for instance, the highest recorded strain for mode 3 at
gauge position 1 is 7. I would like to add another column in this sheet
that tells me if that gauge position is the best, 2nd best, worst, joint
best, joint 2nd best position. The better a gauge position, the higher
the allowable strain it has. So for instance for the example of gauge 1
for mode 3 (for rotor 0) this is the best gauge position (by seeing that
it has the highest allowable strain of all the gauges for that mode and
rotor stage in the first table i.e. it has an allowable strain of 8
which is better than 4 and 7).

How do I get excel to automatically tell me the second table if I am at
the best, worst etc gauge position for each row.
Max showed me how to look up the allowable strain for a given gauge
position, stage and mode:

http://www.excelforum.com/showthread.php?t=486632&highlight=turnipboy

The beauty of his method was that I could add information into the
first table e.g. extra modes, and the spreadsheet did not have a
problem with this. Could a similar thing be done here?

Thanks.