Jump to content

Excel, compare data using formula


rickytheanuj
 Share

Recommended Posts

I have 2 work sheet both contains.

Client No., Name and Balance

These both sheets should have same data.

Mean.

Customer Name of a client no. and his/her balance in sheet 2 should be same as in sheet 1.

But some of Customer Name is not match with his actual client no. or balance.

So I need some how to check if the "CLIENT NO, CUSTOMER NAME AND BALANCE" in sheet 1 is same with sheet 2 or not by comparing both sheets and separate rows, who's client no. or customer name or balance of sheet 2 is not matching with data from sheet1.

if you people need spread sheet, then i'll post it too.

please help me to find the mismatch,

I have to check aprox. 4000 clients. so it's quiet difficult for me

Link to comment
Share on other sites


It mostly depends on the condition if UNIQUENESS of the fields.

I mean, if you have in Sheet #2 Client# listed ONLY ONCE (and/or Client Name listed ONLY ONCE) it would be easier, as you can do a VLOOKUP of sheet#2 on the right of the data you have on sheet #1.

If there are multiple instances of Client# or Client Name on sheet#2 things may get more complex.

jaclaz

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.


×
×
  • Create New...