Hello.

Tried to see if someone had asked this before but dindīt see it.

I have lets say 30 cells. in row A I have numbers from 1-30 and in row B I have names sorted a-z. my question is if I add a name in row B how can I tell Excel to put in row A the next number say 31 and stick with that name when I sort the B row later (A-Z)??

Thank you for your time.

Regards,
Hemmiv