How do I compare sheets in Excel?

Answer by  Hiperlink (13)

Create an empty sheet, then insert the usual Excel comparison formula into the cells, like "=[FILE.xls]Sheetx!A1=[file.xls]Sheety!A1". It works in Office 2003, and it displays a TRUE or FALSE value for every cell. If you are using large sheets, it's a good idea to use conditional formating to color the values for easier spotting of the differences.

Answer by  UmeshG (404)

For that you have to use formula 'VLOOKUP' which you can find in Excel file in formula the formula work like this VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)also you can use "HLOOKUP" and it work like this HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

Answer by  morshedmy (6)

View tab> in the Window group> New Window> Window group>View Side by Side In the workbook>worksheets that you want to compare>Synchronous Scrolling in the Window group on the View tab.

Answer by  logu88 (40)

To find the range ActiveSheet. UsedRange. Rows. Count You can store these in different variables, then use a For loop that goes from1 - to this variable to make comparison.

Answer by  vikkyrs (377)

You can use an additional software like excel compare. It compares an excel file, an excel sheet or parts of sheets.

Answer by  sailendra (63)

Open the original Excel sheet. Click to Tools either by mouse or press Alt+T key while on Excel sheet. Click on Compare and Merge Workbooks and locate the excel sheet to be compared with the original one.

Answer by  RandomDan (489)

You can choose 'New Window' from the file menu. It should open another instance of the same workbook. Simply position the windows side by side and choose the correct sheets in each one.

Answer by  gigo (1706)

Just take pspad and copy the two sheets in two separate pspad pages. Go to the diff menu and compare the two pages.

Answer by  amitkachewar (25)

the excel are available in rows and coloum You compare the sheets in excel. To use the varies formulaies use in excel sheets. automatically calculate any thing but it is compare the sheets.