Hi there,
I am trying to write a formula to pick up all X names from Column A and tell me if all the corresponding values in Column B equal Y.
Any help would be appreciated!
Thanks,
Caroline
Hi there,
I am trying to write a formula to pick up all X names from Column A and tell me if all the corresponding values in Column B equal Y.
Any help would be appreciated!
Thanks,
Caroline
Last edited by Caroline2; 08-15-2018 at 01:26 PM. Reason: More detailed title provided
Moderation request removed. Thanks for changing your thread title.![]()
Last edited by jason.b75; 08-15-2018 at 05:07 PM.
HI Caroline
Something like this:
Formula:
=COUNTIF(A:A,"X")-COUNTIFS(A:A,"X",B:B,"Y")
This will count all occurrences of X in column A then subtract all occurrences where column A is X and column B is Y. If the answer is 0 you will know that all X's in column A have a Y in column B. If it is not 0 it will tell you how many occurrences of X in column A don't have a Y in column B.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
If you just want to check that all X names in column A have Y value in column B then
=COUNTIFS(A:A,"x",B:B,"<>y")
Will tell you how many x names do not have y value in column B, which going by your question should always be 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks