Forum Discussion
Excel number ordering
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.
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.
As a variant:
Since your dates are all properly formatted, consider this formula in A3 and fill it all the way down.
=IF(ISNUMBER(B3),"",N(A2)+1)The N(..) part sees to it that you don't get an error when you add 1 to a cell with "". You will loose the formatting in the first column (blue color and borders), but that can easily be fixed by "painting" the format of any of the other columns on to A and change back the alignment and number formatting to your liking. Your revised file is attached.
You guys are absolute legends and i can't thank you enough,
This is absolutely super,
Thank you so so much 🙂
Dean
