Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |