I need help

[Lassenes]

Hello. I wonder if anyone can help me with this kode problem. If I have a column with dates like this:

A
26 jun
26 jun
26 jun
27 jun
27 jun
28 jun
3 jul
3 jul
5 jul
and so on.....

I would like the result to be like this:

26 jun = 3
27 jun = 2
28 jun = 1
3 jul = 2
5 jul = 1
and so on.....

What kind of formula can do this automatically without needing me to count over first?

mvh Lasse

[daddylonglegs]

If you have a list of unique dates (you can get that by filtering your list to show only unique) then you can use COUNTIF,

e.g. if original list is in column A then unique list in C1 down use this formula in D1 copied down

=COUNTIF(A:A,C1)

[mudraker]

Lassenes

Please read forum rules & use correct thread title

see links below for rules