I am comparing two work sheets and finding mismatching cell in the difference.
My both excel sheets are reading properly. but, while checking the cell in both sheets, it always shows "0" zero values.
Each sheet range starts from A10 to IJ10)
column starts range A to IJ Column in both sheets
Row Starts range 10th row in both sheets.
when cells are merged it won't recognise the correct value. it showing some other value...what could be the problem..?
GaneshPosted Jan 2, 2019, 10:13 PM
Bhuvanesh MohankumarPosted Jan 2, 2019, 3:16 PM
GaneshPosted Jan 2, 2019, 6:59 AM
Madan ShekarPosted Jan 2, 2019, 6:53 AM
It's based on my experience that the value will contain in the first cell of your merged cells.
Have a good day,