Here I need to compare the data in excel
Ex:
-
Amount Reference Final Amount
-
5 A123 10
-
2 A123 10
-
3 A123 10
-
4 A123 10
-
11 A234 12
-
3 A234 12
-
4 A561 4
From the above table, I should get the sum of the amount column for the same reference no and compare it with the final amount column (here in a final amount the sum is not done) if there is any difference I should get the msg.