I need to search my excel sheet based on two pieces of data in two seperate columns.
The data in one column A is a set value and will increment after the data in column B reaches a max value.
Once the data in B is incremented to the max value, column A then increments by some assinged variable and again stays constant and column B begins incrementing again. This repeats in a loop until the final variable in column A has been reached.
Example; A B
1.0 .2
1.0 .4
1.0 .8
1.2 .2
1.2 .5
1.2 .6
1.2 1.0
1.5 .2
1.5 .5
1.5 .8
1.5 1.2
2.0 .2
2.0 .5
2.0 .8
2.0 1.0
2.0 1.5
2.2 .2
2.2 .3
2.2 .4
I need to start at the first value of column A. Then search column B for a specific value. Once the valus is found go to the next value of column A and search B for the same value as previous. This loop continues until the values in Column A have been exhausted.
Hopefully this makes sense and I explained it properly.
The data in one column A is a set value and will increment after the data in column B reaches a max value.
Once the data in B is incremented to the max value, column A then increments by some assinged variable and again stays constant and column B begins incrementing again. This repeats in a loop until the final variable in column A has been reached.
Example; A B
1.0 .2
1.0 .4
1.0 .8
1.2 .2
1.2 .5
1.2 .6
1.2 1.0
1.5 .2
1.5 .5
1.5 .8
1.5 1.2
2.0 .2
2.0 .5
2.0 .8
2.0 1.0
2.0 1.5
2.2 .2
2.2 .3
2.2 .4
I need to start at the first value of column A. Then search column B for a specific value. Once the valus is found go to the next value of column A and search B for the same value as previous. This loop continues until the values in Column A have been exhausted.
Hopefully this makes sense and I explained it properly.
