You are viewing the article How to Compare Data in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 7,437 times.
This wikiHow teaches you how to compare two different sets of data in Excel, from two columns in the same spreadsheet to two independent Excel files.
Steps
Compare two columns
- For example, if the two columns you want to compare start at A2 and B2, select cell C2.
- =IF(A2=B2,"Match","Doesn't match")
Side-by-side comparison of two workbooks
- You can exit this feature by clicking the Synchronous Scrpling button on the Display tab.
Compare, find the difference of two worksheets
- =IF(Sheet1!A1<> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")
- For example, A1 in Worksheet 1 is “Apples” and A1 in Worksheet 2 is “Oranges”. A1 in Worksheet 3 will display “Sheet1:Apples vs Sheet2:Oranges” when using this comparison formula. [2] X Research Source
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 7,437 times.
This wikiHow teaches you how to compare two different sets of data in Excel, from two columns in the same spreadsheet to two independent Excel files.
Thank you for reading this post How to Compare Data in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: