How to display sorted data?

Q

QZantos

I have a spreadsheet with a maintenance record for multiple pieces of
equipment.
I'd like to sort the data and count the number of times the equipment was
serviced.

the spreadsheet looks like:

Equip Date Completed
AC1 1/1/2009
AC2 2/1/2009
AC3 3/1/2009
AC1 2/1/2009
AC3 5/1/2009
AC2 7/1/2009

I can get the data I need by using Autofilter but my spreadsheet has a lot
of equipment, making me perform multiple Autofilters to derive my results.
I would rather have another row added after each piece of equipment with a
count of the number of times the equipment was serviced (something like a
subtotal row)
 
G

Gary''s Student

Put something like this anywhere)
=COUNTIF(A1:A1000,"=AC1")

The data does not even have to be sorted.
 
J

Jacob Skaria

=COUNTIF(A:A,"AC1")

OR

with Equip ID in another cell B1
=COUNTIF(A:A,B1)

If this post helps click Yes
 

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