Hi everyone,

I looked on the forums but was unable to find an instance of what I
was looking for. What I have is a spreadsheet that has several
columns, in column "A" the are part numbers that repeat depending on
the day. in coulmn "B" I have a "yes" if the part is aged over 5 days.
In a hidden worksheet I have a list of problem parts to be on the
lookout for. What I need to do is have a formula that will count the
total number of unique parts over 5 days that is on my problem child
parts list.

Deepest thanks in advance to all!

Sam