Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
For each change in Col. C, Count Unique Numbers in Col. G
I have a list of names in Column C and a list of duplicate and/or unique IDs
in Column G. I'm trying to find a way to count all unique numbers in Column G, for each person listed in Column C (data is sorter by Column C). Any ideas? Thanks, Ryan--- -- RyGuy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
For each change in Col. C, Count Unique Numbers in Col. G
=SUMPRODUCT((C1:C100<"")/COUNTIF(G1:G100,G1:G100&""))
"ryguy7272" wrote: I have a list of names in Column C and a list of duplicate and/or unique IDs in Column G. I'm trying to find a way to count all unique numbers in Column G, for each person listed in Column C (data is sorter by Column C). Any ideas? Thanks, Ryan--- -- RyGuy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
For each change in Col. C, Count Unique Numbers in Col. G
Thanks so much TM. It works, but maybe my data set is too big for this to be
a practical solution. I'm working with a very large amount of data, and it seems to run very slow as I fill down to the lower rows. I think I'm going to try a VBA solution. Thank you very much!! Ryan--- -- RyGuy "Teethless mama" wrote: =SUMPRODUCT((C1:C100<"")/COUNTIF(G1:G100,G1:G100&"")) "ryguy7272" wrote: I have a list of names in Column C and a list of duplicate and/or unique IDs in Column G. I'm trying to find a way to count all unique numbers in Column G, for each person listed in Column C (data is sorter by Column C). Any ideas? Thanks, Ryan--- -- RyGuy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique numbers | Excel Discussion (Misc queries) | |||
VLOOKUPS to Count Unique numbers | Excel Discussion (Misc queries) | |||
Count unique numbers | Excel Worksheet Functions | |||
Count Unique Numbers | Excel Worksheet Functions | |||
Count unique numbers for execs | Excel Discussion (Misc queries) |