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.

Multi_Row_Formula_Tool_Setup.png