How to count rows with changing data


S

Steve in MN

I have an imported list on sheet2 and it is maybe 100 rows. Each day the
data is imported the dates change along with the type of record associated
with each date.

Say this week there are 25 rows with 11/13, 20 rows with 11/14 and 25 rows
with 11/15 and 30 rows with 11/16. Mixed in with this each of these dates
might have a different type of record (each type has 4 options.)

I need to be able to do the following:

1.) I need to count the number of occurrences for each date and not only
show the total count but also show the date that is counted as the label.

2.)count the rows by date and type so I would have potentially 16 results
with totals and be able to display the results along with the labels being
counted.

Example 11/13 --Live -- 20 records
11/13--drop--15 records
11/14 --live--15 records
11/14--drop--12 records

Keep in mind that each day the date range changes, so this would involve
variables or something and I cant figure it out.

Any help would be appreciated.

Thanks
 
Ad

Advertisements

B

Bernie Deitrick

Steve,

Use a pivot table based on your imported data - use date at the row field,
type as either a row field or a column field, and any data type as the data
field, set to count.

There are many sources of help for pivot tables - start with Excel help,
then search the web if you get stuck.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top