Hello everyone,
I've been trying to find a solution to this on the internet but to no success.
My issue is: I need to compare 2 Cell Ranges within an If statement, every element of the first range has to be lower of the corresponding element of the second range, so that I could execute a series of commands, all of this would be within a For, and on each iteration, the size and position of the ranges would change based on an external value.
For example: Range A1:A10 would be filled with 10's, Range B1:B10 would be filled with random numbers I get on previous iterations, then I need to compare A1:A2 with B1:B2 so that B1<A1 and B2<A2, if that criteria is met, I execute some commands AND B1 and B2 both get +1, then on the next iteration I would compare A1:A4 with B1:B4, repeat, then on the next one A2:A4 vs B2:B4, etc, size and position are determined by values on another column
Bookmarks