I have table containing 4 columns each with a name, each row provides a value
or no value against each name, I have created a lookup that returns the name
of the column with the lowest value however, I now want to have 4 columns
containing a name in the order of lowest to highest.

i.e.

Column B = Colette
Column C = John
Column D = Fred
Column E = Joe

B2 = 1.52
C2 = 1.43
D2 = 1.65
E2 = 1.20

I have now added 4 new columns

Column F = 1st
Column G = 2nd
Column H = 3rd
Column I = 4th

and I now want to populate

Row F2 the column name for the lowest value i.e. 1.20 = Joe
Row G2 the column name for the next lowest value i.e. 1.32 = John
Row H2 the column name for the next lowest value i.e. 1.52 = Colette
Row H2 the column name for the highest value i.e. 1.65 = Joe

Actually I found a way of using RANK to achieve what I needed. Thanks

"Colette" wrote:

I have table containing 4 columns each with a name, each row provides a value
or no value against each name, I have created a lookup that returns the name
of the column with the lowest value however, I now want to have 4 columns
containing a name in the order of lowest to highest.

i.e.

Column B = Colette
Column C = John
Column D = Fred
Column E = Joe

B2 = 1.52
C2 = 1.43
D2 = 1.65
E2 = 1.20

I have now added 4 new columns

Column F = 1st
Column G = 2nd
Column H = 3rd
Column I = 4th

and I now want to populate

Row F2 the column name for the lowest value i.e. 1.20 = Joe
Row G2 the column name for the next lowest value i.e. 1.32 = John
Row H2 the column name for the next lowest value i.e. 1.52 = Colette
Row H2 the column name for the highest value i.e. 1.65 = Joe