Cant get my head around a custom sort!

[Dazzawm]

I want to do a custom sort. I want to sort C first by coloured cell, fine. But I then want sort by data in K where they have the same data as whats coloured in C but these cells will be clear! How please?

 

[Alice Morland]

Hi Dazzawm,

I think the way to do that is to have a new column included. There, fill it by a formula =if(C2=k2,"Same","Different").

Then, customer sort first by column C, then by the new column, say by reverse alphabetical order.

Hope this helps.

Alice