Creating unique id's for repeat occurances

I copied the date to column C.

After that text to column.

After that a formula.

=if(countif($B$2:$B11,$B11)=countif($B$2:$B$100,$B11),countif($B$2:$B11,$B11),"")

After that a filter on the desired result (and exclude the empty cells in the count column).

See the attached file.

See the attached file