Hi All,

I have a document with the following data arrays:

Company;
Current Value;
Potential Added Value;
Difference;
Quadrant;
Quadrant ID;

There are 35 values for each column.
There are 4 Quadrants

I would like to know if anyone knows how I can perform the following. And please excuse me for not writing this very technically I am a bit lost.

I need a formula that will will give the outputs as the following:

Company;
Potential Added Value;

This information needs to be ranked based on the following rules:

1. Lowest value (Quadrant ID) that has the highest value (Difference)
2. Second Lowest value (Quadrant ID) that has the second highest value (Difference)......and so on

Then these results need to be shown in 2 columns and linked to to the original data so that the output is the (Company) and the (Potential Added Value).

I hope that this makes sense?