| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find a row in a sheet and compare the complete row /w origi
I have a large excel workbook with two sheets: sheet1 with old values, sheet2
with new values. Most of the values in sheet2 can be found in sheet1, but not all. What I want to do is compare the values from sheet2 with sheet1 (are the values in both sheets)... if they a compare the complete row against eachother. (so all the columns of the particular row should be checked) If they aren't: display a message that the file hasn't been found. How can this be done? Any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Sheet Cell to Sheet Column | Excel Worksheet Functions | |||
| Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) | |||
| using VLOOKUP to compare 2 columns to find new information | Excel Worksheet Functions | |||
| Compare records in multiple sheet -> report | Excel Discussion (Misc queries) | |||
| Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
Linear Mode
