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...
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.