Dynamic sorting using multiple columns

[Frekazoid]

I have three columns which i would like to sort dynamic. I managed to sort using one criteria using the RANK function, but i am really stuck on making it to sort the data using another column as the second criteria.

In the attached document the data from columns F:I is sorted by CAT 2. As in the example, in case of a tie, e.g. T4=T5, i would like to have T4 and T5 sorted by CAT 1 column with the biggest value being the first, here, T5 would be above T4 in column G.

Thanks in advance for your help!

[PeteABC123]

You can create a helper column to the left of your TITLE column. Extract the rightmost digit in TITLE by using something like =RIGHT(H2,1). Now use a custom sort in your table, first by CAT2, then by your helper column, descending. Hide it if you wish.
Peter