• 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.

Best Way to Compare Two Columns on Different Worksheets Using Excel 2007

A

alcharbonneau

New Member
Hi


I would like to compare two columns of data for organizations that are located on different worksheets within the same workbook. Sheet1, Column A contains the 136 target organization numbers. Sheet2 Column A contains the 284 organizational numbers, of the total population and the data, Column B-ADC, for each organization on that particular row.


The goal is to identify the 136 organizations in Sheet2 and delete the remainder of organizations along with their respective data.


Thank you for taking the time to consider/answer this request.


Al
 
Helper column with this formula:

=ISNA(MATCH(A2,Sheet1!A:A,0))

Filter/sort this column, delete all the rows that have "true".


Chandoo has also written several articles about comparing lists.
 
You must log in or register to reply here.
Back
Top