#1   Report Post  
Posted to microsoft.public.excel.misc
Peter Steiner
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
PedroPastre
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default Comparing two tables

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Peter Steiner
 
Posts: n/a
Default 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





  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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






  #6   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default 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.

  #7   Report Post  
Posted to microsoft.public.excel.misc
Peter Steiner
 
Posts: n/a
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing tables in excel with formulas TotallyConfused Excel Discussion (Misc queries) 1 December 18th 05 04:10 AM
Comparing 2 tables with similar content Vic1978 Excel Discussion (Misc queries) 5 December 5th 05 09:06 PM
How to pull numbers from two tables with conditions? Anna Excel Worksheet Functions 1 May 14th 05 03:21 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 02:03 AM
Comparing data in tables Gerrym Excel Discussion (Misc queries) 2 March 3rd 05 09:07 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"