Thread
:
Count
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann