Column A evaluate/validate B to see if the B cells
A1 5 B 4 C
A2 10
without going to the next cell (higher value) fit, writing difference or value into C
I have to do logical test on A1 if true (that B value is less away from each other than A2) and A2 to check wether A1 is true after running B against all A correct? Unless I make an array or something alike to 2 = 2, 3 = 3 etc.. Etc
I think I can start the solving part, make column a array/collections, maybe? Any help welcome
A1 5 B 4 C
A2 10
without going to the next cell (higher value) fit, writing difference or value into C
I have to do logical test on A1 if true (that B value is less away from each other than A2) and A2 to check wether A1 is true after running B against all A correct? Unless I make an array or something alike to 2 = 2, 3 = 3 etc.. Etc
I think I can start the solving part, make column a array/collections, maybe? Any help welcome
