I'm having a hard time with this, and I'd really appreciate some help.
I've got 8 compounds distributed across 4 containers. I need to see if there are any compounds for which the container is empty.
I can use =SUMPRODUCT(1/COUNTIFS(tbl[COMPOUND],tbl[COMPOUND])) to return number of distinct...