LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"