I have a list of, say, products with duplicate values allowed in Column A and various numeric values in Column B (eg sales volumes or sales values) including zero. I want a count of the unique items in Column A that have a zero in Column B.
I'm convinced there should be a (simple?) solution, but can't seem to find one.
I'm convinced there should be a (simple?) solution, but can't seem to find one.