Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to compare a row data from one worksheet to another worksheet
Hi All,
Is there any way I can compare a row data of one excel sheet to that from another excel sheet. The sample data would be as follows: Worksheet1 name : Element list old Contains columns name and data as follows Column name: Element Name, Type, Category, Valid Data.............: ABC,L,Major,Yes Worksheet2 name : Element list updated Contains columns name and data as follows Column name: Element Name, Type, Category, Valid Data.............: ABC,M,Minor,No If any row do not match, then I would like to display either the rows or columns data from Worksheet2 in a new worksheet. Any assistance will be much appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to compare a row data from one worksheet to another worksheet
Excel 2007 PivotTable
Tables, Advanced Filter No formulas needed. http://www.mediafire.com/file/4mg0e2mnj0z/07_02_09.xlsx |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to compare a row data from one worksheet to another worksh
Hi Herbert,
Thank you very much for such a detail help. I was able to open the file, thou it gave some warning message while converting the file from newer version to my version that I am using. Is it possible to save the file in Excel 2003, this will help in seeing the full functionality. Thanks once again for a generous help. Regards Bash "Herbert Seidenberg" wrote: Excel 2007 PivotTable Tables, Advanced Filter No formulas needed. http://www.mediafire.com/file/4mg0e2mnj0z/07_02_09.xlsx |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to compare a row data from one worksheet to another worksh
For $91.99 you can buy Excel 2007,
which is less than three hours of conversion work. Besides, nifty features like dynamic conditional formatting, dynamic horizontal tables, structured references and cool tables styles would be lost. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to compare a row data from one worksheet to another worksh
Thanks Herbert for the suggestion.
However at the moment, the organization I am working for will take some time to buy the excel 2007, as it has to be for the complete organization and they will not entertain my single request. I can see the point and benefit of the new version, but for now unfortunately I am trying to sort this issue of comparing on my own. I will highly appreciate if you could please save the same in excel 2003. Thanks "Herbert Seidenberg" wrote: For $91.99 you can buy Excel 2007, which is less than three hours of conversion work. Besides, nifty features like dynamic conditional formatting, dynamic horizontal tables, structured references and cool tables styles would be lost. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to compare a row data from one worksheet to another worksh
Excel 2007 PivotTable
Due to popular request... Automated with macro. http://www.mediafire.com/file/zzmnvtnznyt/07_03_09.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare all data in one worksheet to another | Excel Discussion (Misc queries) | |||
compare excel worksheet and output difference to new worksheet | Excel Discussion (Misc queries) | |||
Compare a Worksheet to another Worksheet. | Excel Worksheet Functions | |||
Compare worksheets for duplicates and copy data to 1st worksheet | Excel Worksheet Functions | |||
How do I compare similar rows of data in same worksheet | Excel Worksheet Functions |