Hello Everyone,
I have a situation where I am trying to use Power Query to match a list of data (see attached file).
We have Columns - ID, Match, Net, Branch & Dates which are important in this process:
Bank has Positive Numbers in Net Column
OR has Negative Numbers in Net Column
I would like to make a one to one match of Bank Numbers against OR Numbers and populate in Column B (Match) with value - 1 for all those amounts matching.
If the numbers match exactly with each other that's fantastic, but in general it is not the case,
and I am prepared to allow a tolerance limit for the difference from minus 2 to plus 2 (i.e. "-2 <= DIFF <= 2").
So if the compared amounts throw out a difference within this range it can be assumed they are matched.
Some Rules:
- the matching should be between Bank vs OR (absolute values) e.g. 100 against -100 assumed matched
- numbers matching within each branch not against another branch number
- for the moment we can leave out date criteria
Bookmarks