Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
=COUNTIF($A$2:$A$11,$A2)-SUMPRODUCT(($A$2:$A$11=$A2)*(B$2:B$11=B2))=0
... works for both tests.=COUNTIF($A$2:$A$11,A2)-COUNTIF($H$2:$H$11,H2)=0
... assuming the helper column is in column H. That's not as efficient as Barry's proposal (or even mine for that matter!).If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.