Create Unique ID number which refreshes on new day

[paulieCou]

Hi

Im trying to input a function so that a unique ID is generated for each new day entry, where i have specified day as a number not a date.
When it changes to day 2 it does not restart a sequential count from 1
i have tried multiple work arounds but cant figure it

I have 14 days that i will be collecting data over and so that is my value limit of days

=CONCATENATE((C4),"-",COUNTIF(C$4:C4,1))

This is the current formula and i appreciate that this only works for the number 1 and i cant figure it out for others without either returning higher numbers, it falling or error

Thanks
P

 

[Fluff]

Hi & welcome to MrExcel.
How about

=CONCATENATE(C4,"-",COUNTIF(C$4:C4,C4))

 

[paulieCou]

Fluff

Thanks for welcoming me, im not excel trained and so copying and pasting formulas with trial and error has been painfully slow but fun

you hero, it worked! literally one bracket, so annoying haha.

Now, do you know how to add into the formula to show nothing if no day has been allocated?
At present it just returns a -1 otherwise
No issue if not

Cheers

 

[Fluff]

How about

=IF(C4="","",CONCATENATE(C4,"-",COUNTIF(C$4:C4,C4)))

 

[paulieCou]

Thank youuu!

 

[Fluff]

You're welcome & thanks for the feedback.