How do I filter compare 1 worksheet, 1 column of 65,000 against a second worksheet

  • Thread starter Thread starter dabliss74
  • Start date Start date
D

dabliss74

How do I filter 1 worksheet, 1 column of 65000 rows against a second
worksheet of 30 columns,65000 rows?...PLEASE help mE!
 
do a vlookup between a common field in both worksheets. Copy the formula the length of both spreadsheets, then copy paste values. Then filter on each spreadsheet in the vlookup column for #n/a. The lines with that result are not on the other sheet.
 

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 do I make a worksheet have unlimited lines 7
remove excess (unwanted) rows from the bottom of a speadsheet 3
How reference cell in different worksheet 14
Compare 2 worksheets 1
How would I add a loop for this? 3
Combine multiple worksheets in one Workbook into one big worksheet 6
Need help on countif and sumif function with dates and wildcard characters 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top