Forum Discussion
Excel number ordering
deansonline yeah you can do it. put this formula below as I am considering that your data in image starts from 1
In Cell A4,
=If(isnumber(left(B4,1)*1),"",B3+1)
and drag this formula till last Row. Hope this works.
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
Really do appreciate your help,
I don't know what i am doing wrong here, Can you take a look at see if its just me?.. I can't seem to crack it.
Best
Dean
deansonline Sorry got asleep. Please see attached file.
You can keep dragging the formulas and it will work for more data. Meanwhile I have done it for most of them. Just One minute job
Thanks
Kapil