How to display sorted data?
 

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)

How to display sorted data?
 

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

The data does not even have to be sorted.

--
Gary''s Student - gsnu200906


"QZantos" wrote:

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)

How to display sorted data?
 

=COUNTIF(A:A,"AC1")

OR

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

If this post helps click Yes
---------------
Jacob Skaria


"QZantos" wrote:

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)