Creating a new sheet from two others

[clyde]

I have two spreadsheets (call them A and B), each with a list of names and other related info. All listings in A are found in B, but not all listings in B are found in A (so B is bigger). I need to create a new list (call it C) which contains B-A. Can I do this with Excel functions?

 

[Max]

Look for "Extracting Values On One List And Not Another"

in MVP Chip Pearson's:

http://www.cpearson.com/excel/duplicat.htm#Replacing

--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com for email
--------------------------------------------------

I have two spreadsheets (call them A and B), each with a list of names and

other related info. All listings in A are found in B, but not all listings
in B are found in A (so B is bigger). I need to create a new list (call it
C) which contains B-A. Can I do this with Excel functions?

 

[Guest]

-----Original Message-----
I have two spreadsheets (call them A and B), each with a

list of names and other related info. All listings in A
are found in B, but not all listings in B are found in A
(so B is bigger). I need to create a new list (call it C)
which contains B-A. Can I do this with Excel functions?

.
first paste list A to the bottom of B be sure the data

colums match then sort data by name this will put your
duplicates next to each other then delete the duplicates.

 

[clyde]

Max

Thank you very much. The website was very helpful

Clyd

----- Max wrote: ----

Look for "Extracting Values On One List And Not Another

in MVP Chip Pearson's

http://www.cpearson.com/excel/duplicat.htm#Replacin

-
ht
Ma
----------------------------------------
Please reply in newsgrou

Use xdemechani
<at>yahoo<dot>com for emai
-------------------------------------------------

I have two spreadsheets (call them A and B), each with a list of names an

other related info. All listings in A are found in B, but not all listing
in B are found in A (so B is bigger). I need to create a new list (call i
C) which contains B-A. Can I do this with Excel functions

 

[Max]

you're welcome, Clyde!

rgds,
Max