Hello,

I am new to the forums and signed up after finding some very helpful guides. Thank you all who contribute. I have a sorting issue that I need some help on. I will give an example:

Sorting.xlsx


What I want is to sort the original data first by GICS code so that all the right GICS are together. Second, I wanted to sort the data by revenue so that it would like like the above example. I have tried using the rank function and a multitude of other formulas but cannot get it to work. I want to avoid using the sort button because everything else I have built for this spreadsheet have been with formulas. Any help on this would be very much appreciated. If I am not clear, please let me know and I will try to explain it in another way.

Thanks!!