I would like to know how to make it so that it sorts by subscriber count(Lowest to Highest) ➜ Have contacted (Yes is first and no is last) ➜ If they have accepted it on the top if they haven't responded in the middle. IF they decline I would like them to go all the way to the bottom(still being sorted by subscriber account.
I can do this manually by the data and then sort range but I'm looking for an automatic alternative. Any suggestions?
I guess to put it simple is there a way for me to sort data in a hierarchy as well as some data not being in alphabetical order(Example sort [Common, Rare, Legend] or in my case [Accepted, No response, Declined]. But then having it so that if its declined its at the very bottom of the sheet.