How to display sorted data?

[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)

 

[Gary''s Student]

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

The data does not even have to be sorted.

 

[Jacob Skaria]

=COUNTIF(A:A,"AC1")

OR

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

If this post helps click Yes