Hi all,

I'm finding this one a bit tricky.

I need to create unique numbers for the below info

ID. Date

349-006 02/06/14
349-006 02/06/14
349-006 02/06/14
349-006 04/06/14
349-006 04/06/14


The first 3 rows would have the ID of 1 because they share the same date but the other 2 rows would be ID of 2. And so on..

Any ideas guys?

Thanks as always