Classify numbers by relation to each other

[Jordans121]

I have a number in 4 columns from 0-9. (below)

5 1 3 6

I want to label the numbers by their relation to each other...

5= High

1= Low

3=Mid

6=S (super)


It would look like this....

5 1 3 6 H L M S

[alansidman]

Look at the attached. It is a two step process.

[Jordans121]

The formula fails to address the issue. I'm not labeling a specific number. I want to label each number by the relation to the others.

Also, I would like the results to show in the columns F to I

[Haseeb Avarakkan]

Assume the numbers are in A1:D1.

Try this in F1 to copy across.

=CHOOSE(MATCH(A1,LARGE($A1:$D1,{1,2,3,4}),0)+COUNTIF($A1:A1,A1)-1,"S","H","M","L")