Match positive and Negative Amounts

[BRRLL99]

Hi Team,

I have following amounts

date	Type	Amount
16-Apr	NRFB	-100
16-Apr	MC Prsnts	100
16-Apr	MC Prsnts	100
17-Apr	NRFB	-100
16-Apr	MC Prsnts	100
16-Apr	NRFB	-200
16-Apr	MC Prsnts	200

Expected Output :
Date should be same with positive and negative amounts and Negative type should be NRFB and Positive should be MC Prsnts

date	Type	Amount
16-Apr	NRFB	-100	Match
16-Apr	MC Prsnts	100	Match
16-Apr	MC Prsnts	100
17-Apr	NRFB	-100
16-Apr	MC Prsnts	100
16-Apr	NRFB	-200	Match
16-Apr	MC Prsnts	200	Match

[Hsandness]

@BRRLL99 ,

You can use a multi-row formula tool to solve this. See the attached screenshot for the setup and let me know if you have questions.

[Hsandness]

Here's the workflow.

[BRRLL99]

Already tried with Multi row formula looking for more dynamic solution

@DavidSkaife @binuacs @Qiu : Please provide some dynamic solution without multirow formula

[Hsandness]

I created an iterative macro if you don't want to use the multi-row formula tool. I'm curious to see what the other three come up with because an iterative macro, at least mine, is more complex than just using the multi-row formula tool.

I added additional tests and they all passed based on the requirements.