Here is a repost of a prior question.....certainly cleaned up!!

Cells:A2 - A800 are the clients names such as A2 = Client #1, A3=Clients #2
and so forth.

Cells: B1, C1, D1, and E1 are titled with labels: B1 = Extravert, C1 =
Intravert, D1 = Passive, and E1 is Other.

I created a survey where the client answers 1 to 4 for each of the labels.
For example, Client #1 on A2 enters 1 for Extravert, 2 for Intravert, 3 for
Other, and 4 for Passive; however, this is going to be on B2, C2, D2, and E2
respectively under each title.

What I need to do it create a formula that will keep the respective numbers
labels and put the numbers in order from least to greatest. There is a macro
where this data os put in a hierarchy triangle on a different workbook. So
the data triangle is going to be different for each client based on how they
responded to B2, C2, D2, and E2.

I hope this is clearer than my last post....