Check Row by Row

[BRRLL99]

I have following dataset 

Input :

NA	AMT	Brackets
CA	1400.00	1400.00
CA	-1400.00	(1400.00)
4	1400.00	1400.00

Expected Output:
Rules:
1. positive and Negative Same Amount should be matched

2. String and number should be Matched, string and string should not be matched, same with number
in this example string is CA it be can be anything NA, RS etc same with number

NA	AMT	Brackets	match
CA	1400.00	1400.00
CA	-1400.00	(1400.00)	M
04	1400.00	1400.00	M

[RaphaelSilva]

Sorry mate, I don't understand your ruling.
What is driving the new column is column NA?
When you say negative values shoould be the same you want to change (1400) to -1400?
Why first record is not a Match? Values Match

[BRRLL99]

Positive same amount should be setoff with same negative amount

Plus other condition is that NA column should have one string and other number to setoff

CA	-1400.00	M
4	1400.00	M

[RaphaelSilva]

Okay, I think I got the ask
See if the solution is what you were looking for, I used multi-row formula to find the Matches, used it twice to validate and flag both instances.

[BRRLL99]

can we create ABS and Tile columns, because in my original data set can be mixed

NA	AMT	Brackets	ABS	String/Number	Tile
CA	1400.00	1400.00	1400	String	1
4	-1400.00	(1400.00)	1400	String	1
CA	1400.00	1400.00	1400	Number	1

in the given data it is 

CA

CA

4

It can be 

CA

4

CA

[RaphaelSilva · Accepted solution]

What is your patterns regarding which AMT values can be positive and negative?
Is it expect to match different data with the same AMT value?

The workflow below use ABS values to sort the AMTs, then make sure strings appears first and lastly make negative AMTs shows last, so it can map with the "Numbers"
But I don't know what other rules you have in your data

** Please like the replies that helped you and mark as solution once it solves yours problem