LeoRexmundi
New Member
- Joined
- May 29, 2018
- Messages
- 1
Hi!
So here's a broad description of what I want to do:
Given values in column B [1, 6, 3, 18... -5, -6, -22...] I want to write a script that gives a unique tag in column C next to each pair where a positive and negative value will cancel out. EXAMPLE:
B | C
3 | 1
7 |
4 |
1 | 2
-3 | 1
-1 | 2
I know generally how I would get my values into an array and sort and tag them (using a 2xN array where N is the number of values in column B and the second column stores the unique ID) but I'm stuck on getting that tag to display in the correct rows.
Any help would be greatly appreciated [bonus points if you can figure out a way to reference a designated cell that stores a plus/minus tolerance amount and separately tags matches within that tolerance]
Thanks!
So here's a broad description of what I want to do:
Given values in column B [1, 6, 3, 18... -5, -6, -22...] I want to write a script that gives a unique tag in column C next to each pair where a positive and negative value will cancel out. EXAMPLE:
B | C
3 | 1
7 |
4 |
1 | 2
-3 | 1
-1 | 2
I know generally how I would get my values into an array and sort and tag them (using a 2xN array where N is the number of values in column B and the second column stores the unique ID) but I'm stuck on getting that tag to display in the correct rows.
Any help would be greatly appreciated [bonus points if you can figure out a way to reference a designated cell that stores a plus/minus tolerance amount and separately tags matches within that tolerance]
Thanks!