How can you filter one sheet with values from another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to merge two spreadsheets that differ by a couple thousand rows
because one sheet has been cleaned up from erroneous data and the other has
not. They both share a common column which is numerical.
 
1. Change the format of your matching columns to text in both spreadsheets
a. keep both files open
2. Highlight the column you wish to filter
3. Go to Data->Filter->Advanced Filter
4. This data range should appear in List range
5. Click on the reduce button next to Criteria range to get to the spreadsheet
6. Go to your other file with the correct column values
7. Highlight the range you wish to use and click the button again
8. Click OK

Changing the columns to text makes them unique and allows them to be
filtered out.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Merging data from 2 data excel sheets 2
Get information from one sheet to another 2
Pasting into a filtered sheet 3
Filling in another sheet with filtered data 3
Merging over hidden rows 1
Count the columns from one sheet and paste it in another sheet 0
Selective rows from one sheet to another 8

Back
Top