•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?
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]
Want to read more?
Check out the full article on the original site