Comparing two tables
 

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

Comparing two tables
 

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

"Peter Steiner" wrote:

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

Comparing two tables
 

See posts at excel.worksheet.functions, Dec 21
http://tinyurl.com/9gflw

Comparing two tables
 

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


"PedroPastre" schrieb im Newsbeitrag
...
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

"Peter Steiner" wrote:

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

Comparing two tables
 

I would add the second list to the bottom of the first and then use Jim
Cone's commercial Add-in called XL Companion to extract the unique
values........ It's available at

http://www.realezsites.com/bus/primitivesoftware

Vaya con Dios,
Chuck, CABGx3


"Peter Steiner" wrote in message
. ..
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

Comparing two tables
 

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.

Comparing two tables
 

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


"Herbert Seidenberg" schrieb im Newsbeitrag
oups.com...
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.