Hi, is there a way to number or identify rows automatically whichever way you sort it or manual move the row?
I’m trying to find a way to the the row numbers automatically updated depending on how i sort it, whether by date or manually. I have tried rank and it doesnt work. I managedr to find the Find formula that can be used to number rows sorted by dates. But is there another way to do this? For example, if i need to move the row manually?