•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
Tagged with
#AI formula generation techniques
#formula generator
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#Column A
#Column B
#Column C
#missing values
#COUNTIF
#formula
#values comparison
#Excel
#data analysis
#correct formula
#formulas in Excel
#data count
#counting function