Avatar of BeGentleWithMe-INeedHelp
BeGentleWithMe-INeedHelp
Flag for United States of America asked on

Comparing 2 long lists in Excel ? Or another app?

I have 2 long lists (about 10K lines each, let's say)

1 list might look like

a
b
d
e
f
g


and the other looks like:
a
c
d
e
f
h

(some items are in both, some are in 1, not in the other and vice versa).

Is there a way to compare those in excel or elsewhere and have it get rid of the dupes?
so you get a list like:
b
c
g
h

(all items not in both)

or
b
g
(all items in list 1 only)

Thanks!
Microsoft ExcelMicrosoft AccessDatabases

Avatar of undefined
Last Comment
als315

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
als315

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
BeGentleWithMe-INeedHelp

ASKER

Open in new window

So what I am doing is trying to compare 2 lists of files - data I was able to recover from a failed hard drive and the data a recovery service says they can get back.  I did a DIR /s > file and then brought that into excel.  690,000 lines (spaces, directory name, etc plus lots of files).  I tried to sort and it says it can't do that with the resources I have (8GB, new Optiplex PC running win 7 64 bit (although office is 32 bit I think).

Getting the list of files from the recovery service.  I'm looking to see what files are on their list that are not on my dir.  Those are the ones I am missing and I can decide if it's worth their charge.

so the number of records I am dealing with is much larger than I thought before.
BeGentleWithMe-INeedHelp

ASKER
yeah, butter - I did your method and got lots of files that are on both lists, along with those that are unique to either list.

by - I tried yours but after recalc took 5 minutes to do 1%, I hit escape : )

compare it - seems to work - you run a report and it shows differences?  I want to also see whuch are on both list.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
BeGentleWithMe-INeedHelp

ASKER
I have access, so I'll give it a try - new database, 2 tables, each with the single column of file name and then a query to compare the 2?  that last step is probaby where I'll be back here.

als - thanks for that database.  I'll look at that for guidance.

oh.  I created 2 tables.  now how to fill each with the xlsx or csv ?  (access 2010)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
BeGentleWithMe-INeedHelp

ASKER
OK, I am importing the excel sheets into diff. tables.

blogging in real time : )
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.