Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help how to Compare tables in Excel
I would like to know how is the easiest way to take two tables in Excel and
compare against each other and find for instance if there are no matches? Any help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help how to Compare tables in Excel
You can compare two worksheets using VBA if you have a lot of potential
differences using this: http://www.exceltip.com/st/Compare_t...ce l/477.html If you want a way to do it with formulas, please give more info on what's in the worksheets. "TotallyConfused" wrote in message ... I would like to know how is the easiest way to take two tables in Excel and compare against each other and find for instance if there are no matches? Any help will be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help how to Compare tables in Excel
"Barb Reinhardt" wrote: You can compare two worksheets using VBA if you have a lot of potential differences using this: http://www.exceltip.com/st/Compare_t...ce l/477.html If you want a way to do it with formulas, please give more info on what's in the worksheets. "TotallyConfused" wrote in message ... I would like to know how is the easiest way to take two tables in Excel and compare against each other and find for instance if there are no matches? Any help will be greatly appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help how to Compare tables in Excel
I have a lot of potential but I am a Newbie to VBA. The data in my
worksheets is ex: have to identify last names and first names. However, these same names can appear more than once but in different ciities. I want to identify the ones that match and then the unique ones that do not appear in either sheet. Hope this helps. Thanks for any help you can give me. "Barb Reinhardt" wrote: You can compare two worksheets using VBA if you have a lot of potential differences using this: http://www.exceltip.com/st/Compare_t...ce l/477.html If you want a way to do it with formulas, please give more info on what's in the worksheets. "TotallyConfused" wrote in message ... I would like to know how is the easiest way to take two tables in Excel and compare against each other and find for instance if there are no matches? Any help will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Side by Side in Office XP Excel | Excel Worksheet Functions | |||
How can I compare the contents of two Excel files? | Excel Discussion (Misc queries) | |||
How do I set the order of calculation of Data Tables in Excel? | Excel Worksheet Functions | |||
compare tables | Excel Discussion (Misc queries) | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) |