•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to determine what values in Column A exist in Column B?
Our take
If you’re looking to identify which values in Column A are missing from Column B, it’s essential to ensure your formula is set up correctly. The formula you’ve used, `=COUNTIF(B$2:B$3473,A2)>0`, checks if each value in Column A exists in Column B and returns "TRUE" or "FALSE" in Column C. However, if you’re only seeing 118 "FALSE" results instead of the expected 375, there may be an issue with how the data is formatted or how the formula is applied. Let’s explore potential adjustments to
There are 3098 values in Column A and 3473 values in Column B. I'm trying to see what's missing from column A that's in Column B. I used below formula in Column C.
=COUNTIF(B$2:B$3473,A2)>0
But with this formula, in Column C, what comes up as "false" is only 118 values. If formula was correct, I should be seeing 375 values. What's wrong with my formula?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience