• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to track changes in two columns of data

B

brixel

New Member
I am constantly comparing two sets of data (forecasted expenses versus actual expenses) in two different tables. The two tables should have identical number of rows and row descriptions (e.g. Column A100-A200 vs Column A300-A400). My concern is that I might add a row to one table with a new description and forget to add it to the second table.


Is there a way to compare rows of Column A in first table to the rows of Column A in the rows of the second table and alert me in a single cell if something was added in only one of the tables or inconsistent between the two tables?
 
Hi @brixel,


There are many ways to compare two lists... you may want to review some of the other posts on this forum, including a recent one from Hui.

Search for "check-cells-for-equality-follow-up-quick-tip"


Assuming your lists are named "ListOne" and "ListTwo",

you could use something like the following:

=IFERROR("Mismatch at position #" & MATCH(FALSE,IFERROR(ListOne=ListTwo, FALSE), 0), "Everything matches")

entered with Ctrl + Shift + Enter


You could also consider applying a comparison in each list as part of a conditional format, such as to highlight the first cell that is different.


Hopefully, this gives you some ideas.


Cheers,

Sajan.
 
You must log in or register to reply here.
Back
Top