Count

[Newbie]

Hello,
I have the following data (sample):

Code , Code Description, Charges , Counter
1 ABC $20.00
1 ABC $25.00
One code can appear several times with different charges. I want to add a
counter, so that i know how many times the code is repeating. Tried using
Count, Countif it didnt work. any suggestions?

Thanks,
S

 

[Sandy Mann]

If you want a progressive count of the different codes try somehting like

=IF(COUNTIF($A$2:A2,A2)=0,"",COUNTIF($A$2:A2,A2)&" of Code "&A2)

and copy down on the fill handle.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Newbie]

Thank you! It worked.

 

[Sandy Mann]

Glad to be of help. Thank you for posting back

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk