| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to do this?
I auto-filter my spreadsheet down to a general category, and I get 443 rows.
Each row entry is identified with a code that looks like "one or two numbers.one or two numbers.one or two numbers". There are about 110 unique identifiers spread unevenly down these 443 rows. My task is to find out how many rows there are for each unique identifier. I guess I could use the auto-filter and just hit each unique identifier and write down the count, but I'd like to think a code routine could count faster than I can! But I'm not sure how to approach this to make sure I get only the unique identifiers. Any thoughts are appreciated. Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Best way to do this?
Hi
try using a pivot table for this with the column as row item and the count of this column as data item -- Regards Frank Kabel Frankfurt, Germany Ed wrote: I auto-filter my spreadsheet down to a general category, and I get 443 rows. Each row entry is identified with a code that looks like "one or two numbers.one or two numbers.one or two numbers". There are about 110 unique identifiers spread unevenly down these 443 rows. My task is to find out how many rows there are for each unique identifier. I guess I could use the auto-filter and just hit each unique identifier and write down the count, but I'd like to think a code routine could count faster than I can! But I'm not sure how to approach this to make sure I get only the unique identifiers. Any thoughts are appreciated. Ed |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Best way to do this?
Thanks, Frank. That did it.
Ed "Frank Kabel" wrote in message ... Hi try using a pivot table for this with the column as row item and the count of this column as data item -- Regards Frank Kabel Frankfurt, Germany Ed wrote: I auto-filter my spreadsheet down to a general category, and I get 443 rows. Each row entry is identified with a code that looks like "one or two numbers.one or two numbers.one or two numbers". There are about 110 unique identifiers spread unevenly down these 443 rows. My task is to find out how many rows there are for each unique identifier. I guess I could use the auto-filter and just hit each unique identifier and write down the count, but I'd like to think a code routine could count faster than I can! But I'm not sure how to approach this to make sure I get only the unique identifiers. Any thoughts are appreciated. Ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
