Forum Discussion
Formula / Logic Assistance
Hi all, Hoping someone might be able to help me crack a challenge I've been working on and off on for several days. So my objective is to report on what I'll call 'Good' or 'Bad' data by text or ...
In F1:
=IF(A1="", "", IF(COUNTIFS($B$1:$B$10000, A1, $C$1:$C$10000, "<>A")=0, "Good", "Bad"))
Fill down as far as you want.
In F1:
=IF(A1="", "", IF(COUNTIFS($B$1:$B$10000, A1, $C$1:$C$10000, "<>A")=0, "Good", "Bad"))
Fill down as far as you want.
Thanks Hans, I had experimented with similar to this but clearly not quite cracked the right syntax. That'll work a treat! Good fix!
