Excel Help

[sastrypvn]

Hi,

Can anyone help me in writing the formula for the below

In the having a data shown in the below table..

I need a formula which can bring all brands which is having a rank 1 in a single cell.

Brand 1 Brand 2 Brand 3 Brand 4 Brand 5 Brand 6 Brand 7
Value 4.0 3.6 3.8 4.0 3.9 4.0 4.0
rank 1 7 6 1 5 1 1

Thanks in advance.

Regards,
Sastry

 

[Asala42]

Use the RANK formula.

in A3:
=RANK(A2,$A$2:$G$2)
then copy across.