Comparing two tables

P

Peter Steiner

hey just a short question :-D
I have two tables, one with a list with 1330 entries and one with 720
entries, the 720 are all in the big list as well, is there a way to write
the 610 entries from the big list that arent in the small list into another
excel table without doing it one by one ?
thanks in advance
Peter
 
P

PedroPastre

PEter,

try to use the "VLOOKUP" function...it will help you to identify with values
are in both tables (sheets)... so you can mark the values that are in both
tables and separete then easily...

i don´t know if you know the VLOOKUP function...if you don´t...check it out
at EXCEL help ...there have a good material about this!

i hope this help you!

Pedro
 
P

Peter Steiner

i checked the vlookup function, but it didnt really help OR i just didnt
understand it ...
from what i found online i couldnt make, it seems like it only checkes for a
value in one
sheet and grabs the corresponding value from a second one ... but that kinda
doesnt
work out, because the lines arent identical

maybe i didnt describe it right, let me "paint" it

sheet one: sheet two:

1 1
2 2
3 4
4 6
5
6

the function i need would return

sheet three:

3
5
 
H

Herbert Seidenberg

Please review the link http://tinyurl.com/9gflw
Sloth highlights the numbers 3 and 5
with conditional formatting and then he erases them.
Since you want to save those numbers, just do the opposite.
Instead of
=COUNTIF(Range,Criteria)=0 use
=COUNTIF(Range,Criteria)>0
Two alternate ways are listed using Advanced Filter and array formulas.
Modify them in a similar way.
 
P

Peter Steiner

oooooh
thank you soooo much, i checked the link but it somehow didnt do what i
wanted, now i found what was
wrong, first i had the exchange the order of the two lists and second was
the > instead of =
thank you very much
 
Top