How to compare column and spot the difference
Closed
norasiken
Posts
1
Registration date
Tuesday August 22, 2017
Status
Member
Last seen
August 22, 2017
-
Updated on Aug 22, 2017 at 10:08 PM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Aug 25, 2017 at 02:59 PM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Aug 25, 2017 at 02:59 PM
Related:
- How to compare column and spot the difference
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
- Difference between fat16 and fat32 - Guide
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- VBA Compare 2 sheets and output difference to 3rd sheet - Excel Forum
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Aug 25, 2017 at 02:59 PM
Aug 25, 2017 at 02:59 PM
norasiken, Good afternoon.
Suppose your data at A1:D6
Try to use:
E2 --> =IF(VLOOKUP(C2,$A$2:$B$6,2,FALSE)<>D2,"Error","")
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose your data at A1:D6
Try to use:
E2 --> =IF(VLOOKUP(C2,$A$2:$B$6,2,FALSE)<>D2,"Error","")
Copy it down.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão