+1 to duplicates

[pauldaddyadams]

Hi,

I have a formula but it isn’t working.

What I would like is for a formula where if there is a duplicate in column D it adds one onto it. If its unique its 1.

Can anyone help please?

[smls]

try this maybe

Please Login or Register  to view this content.

put it in I6 and drag down

[JieJenn]

Maybe try

=IF(COUNTIF($D$6:$D$12,D6)=1,E5+1,COUNTIF($D$6:D6,D6))

[FDibbins]

or this...
=COUNTIF($D$6:D6,D6)+IF(ISNUMBER(D5),IF(COUNTIF($D$6:D6,D6)=1,1,0))