Identify missing values

Originally Posted by VBA Noob

Without a array
Quote:
=SUMPRODUCT(--(B2:B6={"A","B","C"}))

This only returns a value of 5 for all the columns, even if A is not present. I wanted it to return "A" the row after "A" hasn't been present for 5 days.
In situations where A or B isn't present, return A and B in the cell...

Any ideas?