Greetings:
I have several spreadsheets that I need to get data counts on. The rows are
names and addresses with a 3 digit store number in each row. There are a
total of 112 different store numbers (125, 323, 442,...). There are over
10,000 rows in each file. Not all store numbers are used in all files
(varies).
I can use =COUNTIF(H2:H5982,580) to tell me how many records are for store #
580. Is there a way that I can get a listing of each store number with the
number of records associated with that store number without doing a lot of
manual work?
Any pointers would be greatly appreciated!
Thanks!
nan
