Duplicates IF Function Question

[jimmybangs]

Hi There,

I have a quick question about automating a duplicate scenario within Excel. A bit of background - I run a sales office in which we have Lead Generators booking meetings for other account managers to do sales calls. On our sales tracker we would like to know whether or not should we re-contact somebody in six months that a meeting has taken place??

With this is mind is there a simple function that can count duplicates and format them in the format shown within the below link

http://screencast.com/t/NjU3ZGM2M2Et

I look forward to hearing from you shortly.

James

 

[JimM]

try in cell C2

=COUNTIF($A$2:A2,A2)

and copy down

However this won't give you the same result as in your example but I'm hoping that where you have the forst Ford (cell c3) should be 1 ??

HTH

Jim