Date Formula

[superfb]

Hi


Can anyone help me think of a formula where if i have multiple dates in one column, the column next to it will differentiate it by putting - 2, -3,-4 for ex see below
col A Col B
[TABLE="width: 166"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]20060704[/TD]
[TD]20060704[/TD]
[/TR]
[TR]
[TD]20060704[/TD]
[TD]20060704-2[/TD]
[/TR]
[TR]
[TD]20051222[/TD]
[TD]20051222[/TD]
[/TR]
[TR]
[TD]20051222[/TD]
[TD]20051222-2[/TD]
[/TR]
[TR]
[TD]20051205[/TD]
[TD]20051205[/TD]
[/TR]
[TR]
[TD]20051205[/TD]
[TD]20051205-2[/TD]
[/TR]
[TR]
[TD]20051205[/TD]
[TD]20051205-3[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

Try this:

=A1&IF(COUNTIF($A$1:A1,A1)>1,"-"&COUNTIF($A$1:A1,A1),"")

 

[superfb]

Thank you for the reply however this doesnt create the -1,-2,-3 if a date appears 3 times

 

[steve the fish]

If you have those values in column A and type the formula in B1 and drag it down then it does.

 

[superfb]

If you have those values in column A and type the formula in B1 and drag it down then it does.

Thank you works a treat - can you explain for my understanding how this formula operates?

thanks