vefarc.blogg.se - Hot to make for loop in matlab for step

Firstly, the first OFFSET function’s rows argument will be modified like this: MAX(ROW(C$5)-ROW(C5)+3,0).

The second OFFSET function’s rows argument has decreased from 0 to -3 and height argument has increased from 1 to 4.

Finally, do you find some patterns from the above formulas? The first OFFSET function’s rows argument has decreased from 3 to 0 the height argument has increased from 1 to 4.

For example, for cell C6, our formula will not be like the formula for cell C11: =OR(OFFSET(C11, 0, 0, 4, 1)-OFFSET(C11, -3, 0, 4, 1)=3).

Now, for cells C5 to C7, we want that the formula will not take into consideration the upper 3 cells.

So the formula should be modified for these cells. But for cells C5, C6, and C7 this formula cannot work. This formula can work from cell C8, above cell C8, there are 3 cells.

So, I think you have got the whole concept of how this algorithm is going to work.

So cell C11 gets true values as returned. What will this formula return? The first offset function of the formula will return array:, you get TRUE. Say for cell reference C11, I can write the formula like this: =OR(OFFSET(C11, 0, 0, 4, 1)-OFFSET(C11, -3, 0, 4, 1)=3).

Here, I can do that easily using the OFFSET function as the OFFSET function returns an array.

Then I shall find out the difference of the arrays if any of the differences is equal to 3 that the reference cell will be TRUE valued. For a reference point (like C11 or C17), I shall take a total of 7 cells around it (including the reference point) and place them side by side in the formula creating arrays. Before building the common formula, I shall show what the formulas will be for the cells C11 and C17 and then will modify the formula to make it common for all. So, let’s build the algorithm with keeping the above pattern in mind.

But for the second part, there is no such pattern. From the first part, you can find a pattern from the image. You will get an imaginary picture like the following. Reference cells are C11 and C17 and I am taking a total of 7 cells around the reference cell. Now, imagine I am taking the values of cell ranges C8:C11 & C11:C14, and C14:C17 & C17: C20 side by side.If you are used to Excel formulas, then you can smell the OFFSET function, as OFFSET function works with reference points. In cells C11 and C17, the values are 10 and 20 respectively (above image). Here, to make you understand the algorithm easily, I will explain the whole thing with two reference cells: cells C11 and C17.