I have 2 sets of data, name and amount. I have do the reconciliation by keep them as separate outputs. We need a status column as Matched or Not Matched and an Unique Identification for each Match in the output. How do we do this in macros?
Input 1:-
| Name | Amount |
| A | 10 |
| A | 10 |
| B | 10 |
| C | 30 |
| D | 40 |
| E | 50 |
Input 2:-
| Name | Amount |
| A | 20 |
| C | 30 |
| D | 40 |
| D | 60 |
| E | 50 |
Output 1:-
| Name | Amount | Result | Matching Code |
| A | 10 | Match | 1 |
| A | 10 | Match | 1 |
| B | 10 | Not Matched |
| C | 30 | Match | 2 |
| D | 40 | Not Matched |
| E | 50 | Match | 3 |
Output 2:-
| Name | Amount | Result | Matching Code |
| A | 20 | Match | 1 |
| C | 30 | Match | 2 |
| D | 40 | Not Matched |
| D | 60 | Not Matched |
| E | 50 | Match | 3 |
