I have a list of 3-digit numbers I want to use.
I want to categorize each number as follows:
L=Lowest M=Median H=Highest
E.g.
The number 123 has the following combinations: 123, 132, 213, 231, 312, 321
and
123 = LMH
132 = LHM
213 = MLH
231 = MHL
312 = HLM
321 = HML
A number like 799 would be
I would like a function in Excel to take any such list of numbers (say in A) and find their LMH etc equivalents in a separate column B.
Thanks in advance.
Bookmarks