Thanks guys but I managed to sort it, with the following:

=(COUNTIF($D$1:D2,D2))

AND

=D2 & "." & TEXT(AD2,"000000")