Forum Discussion
Excel number ordering
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
- deansonlineMay 06, 2020Copper Contributor
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
- jukapilMay 07, 2020MCT
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
- SergeiBaklanMay 06, 2020Diamond Contributor
It looks like you are working with Pivot Table. I'm not sure if data model is available on Mac, if so you may add calculated column with ID into the model and use it. For such sample
such column could be calculated as
= CALCULATE ( COUNTA ( Table1[N] ), FILTER ( Table1, Table1[D] = EARLIER ( Table1[D] ) ), Table1[N] <= EARLIER ( Table1[N] ) )If not, perhaps you may add helper column to the source data calculating unique names ID for each datetime.
- deansonlineMay 06, 2020Copper Contributor
Thank you for your reply,
Sad to say i have no idea what im doing, I thought this would be a simple process but how wrong am i 🙂
I may have to just carry on doing all this manually.