Creating a new sheet from two others

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

Guest

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?
 
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
--------------------------------------------------
clyde said:
I have two spreadsheets (call them A and B), each with a list of names and
Click to expand...
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?
 
-----Original Message-----
I have two spreadsheets (call them A and B), each with a
Click to expand...
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
Click to expand...
colums match then sort data by name this will put your
duplicates next to each other then delete the duplicates.
 
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
-------------------------------------------------
clyde said:
I have two spreadsheets (call them A and B), each with a list of names an
Click to expand...
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
 
Back
Top