Forum Discussion
Excel number ordering
Hi Everyone, My name is Dean, I've spent the last few weeks struggling to learn excel and now i need a little help if possible... Does anyone know of way to quickly number each name as I've d...
Thanks for getting back to me so quickly, unfortunately ive copied and pasted it and its still counts without resetting.
I don't know if this will help....
i have attached another picture, I have a column that i don't need and that i am happy to copy and paste over it. as soon as there is a gap i need to it reset back to 1 and count again.
Thank you very much for your time
deansonline seems your dates are different format. Use the same formula and drag it till end. Then Please activate the filter in Column B and do filtering by when contains = 2020. This will filter the date rows then select Column A and press delete. Then it will reset the numbers.
Hope your name does not contain 2020