I'm looking for a formula to sort 3 columns based on 1 column of numbers.
D, E, F columns should sort on column C. I can do this using macros but I'm trying to stay away from macros in this sheet. Column C is just 1 - 11. I tried using the (RANK) function but couldn't get it to work.
Anyone have experience with using a formula to sort?
Bookmarks