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

Extract data from a table

G

GN0001

Member
I have two workbooks:

first 624rows

second 124 rows

both back end and front end have duplicates, how to pull the data? what is the function?
 
Start with extracting a copy of a Key Column from each Page

Copy the two columns, one under the other on a new page

Then use an Advanced Filter extract unique records.

Use this list of unique records to then extract data from the 2 source tables using Index(Match()) formulas
 
You must log in or register to reply here.
Back
Top