My assumption is that you want to identify the discrepancies between the Accounting and Bank columns. There are many duplicate numbers so it's not possible to say with amount of -200 in Accounting relates to which -200 in Bank.

You can use Power Query to count the number of occurrences for each amount in both lists and then compare where these counts are not equal. The attached file contains a very crude example and produced a list of 39 discrepancies, most of which for amounts that occur only once in one of the lists. And then there are several amounts that occur in both lists but not the same number of times.

This list would be the starting point for further analysis, of course.

How did Power Query count the number of occurrences for each value in both lists and then compare where these counts are not equal.
I am a beginner in excel.

Thank you.

Okay, PQ isn't difficult to learn but it takes some effort to get started. Consider taking some of the courses offered on this site.

In PQ you can group lists or tables and have it count, sum, average etc.. Do that for each list and then you compare both in a process called 'merging'. That's what I've done in the file I attached to my previous post. But, I admit it's hard to follow if you have never worked with PQ before.

You could do something similar in separate steps in Excel. But that's all manual work. Doable with pivot tables and lookup functions, but since you mention to be a beginner that's not going to be straight-forward either.

Another easy (but laborious) way would be to sort both lists in ascending (or descending) order, next to each other, and visually see if the numbers in all 1700+ rows line up. if not, insert an empty cell where a number is missing to indicate an item that doesn't reconcile. Not recommended, though, if you have to do this many times per day/week.