Count

N

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
 
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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top