Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting? Not sure
Greetings from sunny Florida,
I have a column of sorted ID numbers in column A. I am trying to create totals in column B that counts how many times the ID number appears in column A. Is there a way to make this: 101902 101903 101903 101906 101909 101910 101910 101910 101912 101914 101917 101918 101918 Look somethng like this? 101902 1 101903 101903 2 101906 1 101909 1 101910 101910 101910 3 101912 1 101914 1 101917 1 101918 101918 2 Many thanks, Mike Saffer -- Mike Jacksonville, Florida |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting? Not sure
Extract a unique list using datafilteradvanced filter, copy to another location and unique records only, if you already have a list skip that step. Then in an adjacent cell to the unique list put (assume the first unique value is in C2 and the list you want to check with is in A2:A100) so in D2 enter =COUNTIF($A$2:$A$100,C2) copy down Regards, Peo Sjoblom Mike Saffer wrote: Greetings from sunny Florida, I have a column of sorted ID numbers in column A. I am trying to create totals in column B that counts how many times the ID number appears in column A. Is there a way to make this: 101902 101903 101903 101906 101909 101910 101910 101910 101912 101914 101917 101918 101918 Look somethng like this? 101902 1 101903 101903 2 101906 1 101909 1 101910 101910 101910 3 101912 1 101914 1 101917 1 101918 101918 2 Many thanks, Mike Saffer |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting? Not sure
With the data in A1:A13, in B1
=IF(COUNTIF(A1:A13,A1)=1,"",COUNTIF(A1:A13,A1)) And drag it down to B13 If you want to do calculations with the numbers in column B, change the "" to 0, Regards, Alan. "Mike Saffer" wrote in message ... Greetings from sunny Florida, I have a column of sorted ID numbers in column A. I am trying to create totals in column B that counts how many times the ID number appears in column A. Is there a way to make this: 101902 101903 101903 101906 101909 101910 101910 101910 101912 101914 101917 101918 101918 Look somethng like this? 101902 1 101903 101903 2 101906 1 101909 1 101910 101910 101910 3 101912 1 101914 1 101917 1 101918 101918 2 Many thanks, Mike Saffer -- Mike Jacksonville, Florida |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting? Not sure
Assuming your data starts in A1, enter this in B1:
=IF(A1=A2,"",COUNTIF(A:A,A1)) Copy down column B as far as needed. HTH, Elkar "Mike Saffer" wrote: Greetings from sunny Florida, I have a column of sorted ID numbers in column A. I am trying to create totals in column B that counts how many times the ID number appears in column A. Is there a way to make this: 101902 101903 101903 101906 101909 101910 101910 101910 101912 101914 101917 101918 101918 Look somethng like this? 101902 1 101903 101903 2 101906 1 101909 1 101910 101910 101910 3 101912 1 101914 1 101917 1 101918 101918 2 Many thanks, Mike Saffer -- Mike Jacksonville, Florida |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting? Not sure
Thank you Peo, Elkar and Alan for offering solutions. I was able to use your
information and it my sheet work s great now. Regards, -- Mike Jacksonville, Florida "Mike Saffer" wrote: Greetings from sunny Florida, I have a column of sorted ID numbers in column A. I am trying to create totals in column B that counts how many times the ID number appears in column A. Is there a way to make this: 101902 101903 101903 101906 101909 101910 101910 101910 101912 101914 101917 101918 101918 Look somethng like this? 101902 1 101903 101903 2 101906 1 101909 1 101910 101910 101910 3 101912 1 101914 1 101917 1 101918 101918 2 Many thanks, Mike Saffer -- Mike Jacksonville, Florida |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |