Hello i have a query to compare two similar excel sheets. i.e, i have two excel files. "Excel1" has sheet1 present in my local drive. "Excel2" has sheet2 exported from page2 from my application. Now i want to compare these two excels has similar columns and values.
My Idea: I thought to import these two sheets to tool, "Excel1" to global sheet and "Excel2" to Action sheet and compare the values. But the twist is i am not sure about
1.the number of columns present
2.number of rows present
So can you suggest a good idea to work on this.
- One thing you can't recycle is wasted time -