Count
 

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

Count
 

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


Replace @mailinator.com with @tiscali.co.uk


"Newbie" wrote in message
...
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

Count
 

Thank you! It worked.

"Newbie" wrote:

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

Count
 

Glad to be of help. Thank you for posting back

--

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


Replace @mailinator.com with @tiscali.co.uk


"Newbie" wrote in message
...
Thank you! It worked.

"Newbie" wrote:

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