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
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