Is there a way to compare two excel sheets?



Is there a way to compare two excel sheets?..

Answer / Prabhu Dayal Bajpai

Yes, you can compare two Excel sheets by using various methods such as VLOOKUP, INDEX MATCH, and conditional formatting. Additionally, Microsoft offers a tool called Power Query which allows for more advanced comparisons between data sets.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What do you mean by freeze panes in ms-excel?

1 Answers  


Why my excel is blank?

1 Answers  


What is goal seek in excel with example?

1 Answers  


How do you row and column in excel 2007?

1 Answers  


How could you insert a new row between rows 20 and 21?

1 Answers  


How do I find duplicates in excel 2003?

1 Answers  


How do I start excel?

1 Answers  


What is spreadsheet explain?

1 Answers  


What is a pivottable, and when would you use one? What are the key pivottable ‘sections’ into which users can drag columns?

1 Answers  


What are functions how functions are used in excel?

1 Answers  


I am using excel and I want to print only the bottom of the worksheet. There is not an option to do this in the print dialog box. How can this be done?

1 Answers  


How do you select multiple rows in excel to delete?

1 Answers  


Categories