If your goal is to actually have each unique value with it's count in one cell seperated with a comma you could try this rather long formula:

Formula in `C1`

:

```
=TEXT(INDEX($A$1:$A$13,SMALL(INDEX((MATCH($A$1:$A$13&"",$A$1:$A$13&"",0)<>ROW($A$1:$A$13))*10^10+ROW($A$1:$A$13),0),ROW(1:1))),"dd/mm/yyyy")&","&COUNTIF($A$1:$A$13,INDEX($A$1:$A$13,SMALL(INDEX((MATCH($A$1:$A$13&"",$A$1:$A$13&"",0)<>ROW($A$1:$A$13))*10^10+ROW($A$1:$A$13),0),ROW(1:1))))
```

Drag down...

Hindsight, your requirement was different but i'll leave the other option there for future reference. With headers and a column for unique values and another one for the appropriate count see example below:

Formula in `C2`

:

```
=INDEX($A$2:$A$14,MATCH(0,INDEX(COUNTIF($C$1:C1,$A$2:$A$14),0),0))
```

Formula in `D2`

:

```
=COUNTIF($A$2:$A$14,C2)
```

Drag both down...