Hi!

COL_A COL_J COL_H
Date Type of Failure Part # Failed
10/20/2005 Supplier - Porosity 1357 - Gasket

Other than the date, what data is in what column? It looks like the date is
in column A.

What's in column J? Supplier? Supplier - Porosity?

Biff

"Racorfrank" wrote
in message ...

I have data that increases on a daily basis and is input on the shop
floor from a drop-down list. Some of the data that is collected
includes day, the type of failure and the corresponding part that
failed.

For example:
COL_A COL_J COL_H
Date Type of Failure Part # Failed
10/20/2005 Supplier - Porosity 1357 - Gasket
10/20/2005 Internal - Cracked 5678 - O-Ring
10/20/2005 Internal - Split 2345 - Seal
10/20/2005 Internal - Pinched 1234 - Seal
10/20/2005 Internal - Pinched 1234 - Seal
10/20/2005 Internal - Pinched 1234 - Seal
10/20/2005 Internal - Pinched 1234 - Seal
10/21/2005 Internal - Pinched 1234 - Seal
10/21/2005 Internal - Cracked 5678 - O-Ring
10/21/2005 Internal - Cracked 5678 - O-Ring
10/21/2005 Internal - Cracked 5678 - O-Ring
10/21/2005 Internal - Cracked 5678 - O-Ring

I somehow need to develop a formula that will count the types of
failures and the corresponding part number that failed by the day it
occurred. I can do a COUNTIF but it cannot do all that is asked. I also
tried to filter by date then use COUNTIF, but it still looks at all data
in the column.

Can someone point me in the right direction?


--
Racorfrank
------------------------------------------------------------------------
Racorfrank's Profile:
http://www.excelforum.com/member.php...o&userid=17882
View this thread: http://www.excelforum.com/showthread...hreadid=479556