Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting unique numbers
Hello everyone,
I have a large set of data that has in one column, the company id which repeats on consecutive rows for each year in the dataset. Then in the next column, there's the ID of each segment within the company (a number). I need to count for each company code, how many segments (unique numbers) are there. The data for a small sample looks like this: COMP-ID SEG-ID 1001 1 1001 1 1001 1 1003 1 1003 1 1003 1 1003 1 1004 3 1004 4 1004 5 1004 3 1004 4 1004 5 1004 3 in this case I would need to generate a list like this 1001 1 1003 1 1004 3 which means that company 1001 has 1 segment, 1003 has 1 segment and company 1004 has 3 segments (segments 3, 4 and 5). I hope anybody can shed some light on how to tackle this one because I haven't been able to figure something out. Thanks in advance, Juan Marin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting and unique | Excel Discussion (Misc queries) | |||
Counting Unique | Excel Worksheet Functions | |||
Unique counting | Excel Discussion (Misc queries) | |||
Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
counting unique numbers in filtered data | Excel Worksheet Functions |