#### fluffynicesheep

##### New Member

- Joined
- Oct 27, 2009

- Messages
- 49

e.g. cell P2 contains the text "highly motivated" and Q2 contains the number 8 (for 8 out of 10)

I have just manged to sort the numbers in column Q into order by entering the formula below in cell S2 and dragging it down.

=LARGE($Q$2:$Q$14,ROW()-ROW($1:$1))

However, what I now need to do in column R is to get the soft skills themselves re-appearing in the new order.....

I'm unsure of the formula to do this at the moment.

Any help would be greatly appreciated!