开发者

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 !)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜