Look for value Within Column

[BRRLL99]

@Qiu, @flying008 , @binuacs

Hi Team,

There is slight change in data from my previous query

Input:

NewValue
0
0
0
6800
-6800
-6800
-6800
928
-928
-928
928
100
300
400
-400
800
800
800
800
1200
1200
-1200

Expected Output:
1. By default 0 should M
2. positive or Negative same values should be matched ex: 6800 is in 1:3 ratio then it is M

3. 800 does not have any negative values, then it is no match

NewValue	Match
0	M
0	M
0	M
6800	M
-6800	M
-6800	M
-6800	M
928	M
-928	M
-928	M
928	M
100
300
400	M
-400	M
800
800
800
800
1200	M
1200	M
-1200	M

[aatalai · Accepted solution]

@BRRLL99  this should do the trick, let me know how you get on

[usmanbashir · Accepted solution]

@BRRLL99 - See attached workflow. Hope this helps!