Hi Guys,

I need a formula to count the amount of dates whilst only counting the duplicates once. So the formula next to 128809 will = 4, as there are only 4 dates (ie the 07/01/2015 is counted as 1 not for 2). the formula will need to work consequtively down the spread sheet. Next to 202032 the formula should = 1 and next to 201727 the formula should equal 2

Below is the example (Note two columns are being used, A & B):

128809 30/10/2014

128809 29/10/2014

128809 05/11/2014

128809 07/01/2015

128809 07/01/2015

202032 05/03/2015

201727 28/03/2015

201727 29/03/2015

201727 29/03/2015

I have been working with IF, CountIF, Sum, Match and Frequency, but i just cant get it right.

any help is appreciated.

THanks guys :D

## Bookmarks