Hi Pecoflyer,



You're talking to an oldie who's Excel knowledge is pretty basic. I thought about putting in a separate column with number 1, 2, 3 etc., and hiding that but how can I get the sheet to sort by that column. For clarity, there are other columns that rely on each row so when I insert the sort filter they all become live, so to speak. The only other column that I need to sort by is the alpha one, and that sorts OK. Looked at 'Sort By' and that might do the trick, but how would I go about inserting that based on the above.

Could you be a bit more specific please, I don't understand what's wrong
Have you seen how my solution works?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post