Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does Excel 2007 support worksheet compare?
Does anyone know if Excel 2007 has added a feature to compare two worksheets
and highlight differences? It looks like earlier releases required a third-party addin for this. Thanks, Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does Excel 2007 support worksheet compare?
Not that I'm aware of. However, there may be a way to easily compare the two
sets of data. Provide some information on the data you want to compare. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Paul Huelskamp" wrote: Does anyone know if Excel 2007 has added a feature to compare two worksheets and highlight differences? It looks like earlier releases required a third-party addin for this. Thanks, Paul |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does Excel 2007 support worksheet compare?
Dave F - here is my specific question. I have two sheets - TEST One and
TEST Two. In Test One I have 1000 part numbers with 10 columns of data about that part. In Test Two I have 25 part numbers - I want to know do any of my 25 parts in Test Two exist in Test One. I want to do this without having to do 25 finds. If excel can do this, can it produce a third spreadsheet with the results? For example it finds 10 matches - will it parse those 10 out in another sheet with the list of the 10 columns of information? Please advise - thank you in advance for your help. "Dave F" wrote: Not that I'm aware of. However, there may be a way to easily compare the two sets of data. Provide some information on the data you want to compare. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Paul Huelskamp" wrote: Does anyone know if Excel 2007 has added a feature to compare two worksheets and highlight differences? It looks like earlier releases required a third-party addin for this. Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add link to specific Excel worksheet in HTML Outlook message | Links and Linking in Excel | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
How can I make charts printable in a worksheet in Excel 2007? | Charts and Charting in Excel | |||
Excel 2007 Worksheet | Excel Discussion (Misc queries) | |||
Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) |