Excel Formula Help Needed
Here is 2 columns of data. I need to write a formula to compare the two开发者_如何学Go columns. The end result is I want to know which in column A are not in column B.
COL-A COL-B
1023 1023
1024 1024
1025 1025
1026 1026
1028 1028
1029 1029
Can we write formula for this? or we have to write macro? I am not in advance to write macro it its required :( help me please
Put this formula in C1
:
=NOT(ISNA(VLOOKUP(A1,B:B,1,FALSE)))
And expand downwards. It will be TRUE
if the value in column A
exists in column B
.
For the record, your example data is identical in both columns, so it will always be TRUE
.
Not sure this is your question, but to compare row by row, without programming AND without formula:
- highlight the 2 columns,
- then press ctrl+G (shortcut for Go To),
- click on Special button
- Select Row differences
That's it, Excel has selected all cells in second column that are different from the first column. Just click on a color button to keep the result visible.
You can of course program that as well. try recording it if you're nowhere with programming. (look Ma...no hands !)
精彩评论