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

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
>
>
>

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

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" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> 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
>>
>>
>>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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.

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" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> 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.
>