I am looking to get a column of numbers with a single highest value from multiple rows with the same numbers within it.



The initial data is:
Change.....No1.....No2.....No3.....No4.....No5
0.....200.....100
0.....300.....200.....100
10.....400.....200.....100
0.....500.....400.....200.....100
0.....600.....500.....400.....200.....100
20.....700.....600.....500.....400.....200.....100



What I want to end up with is
Change.....No1
20.....100
20.....200
0.....300
20.....400
20.....500
20.....600
20.....700

In the example I have two numbers that could drive the change 10 & 20.

I want a list with the maximum amount of change against each of the numbers hence in this example you only see the 20 in what I want to end up with data..

The lines could have up to 25 entries in them on multiple lines.

Any ideas on how this could be achieved.