In last post, we discussed static methods to create sequence of numbers, now we are going to discuss about dynamic methods to create sequence of numbers.
Before getting into the construction of function, let me tell you something about Row, Column, Rows and Columns functions. Because those functions play major role in our requirement.
As shown above, only argument of row function is reference and that too optional argument,
If you feed any range in that argument, it will provide the row number of that range. For ex., if you feed B10 in row function, result of that function is 10. If you ignore that argument and close that parenthesis, function will exhibit the row number of active cell.
If you feed B10 in Column function, result of that will be 2, and if you ignore the argument and close the parenthesis then it will exhibit the column number of active cell.
Instead of single cell reference, I will feed range of cells in reference arguments and let's see what the results will be.
Row function will deliver the row of each cell in the range fed in the argument, and it will throw below result.
Instead of D3, if we start the range from D1 then sequence of number will be generated from 1 to 9. Same can be done across columns using column function.
Row function gives the row number of the given reference, in the same way Rows function gives the number of rows in given reference or range.
as in the same example as above, if we wrap the range with Rows function, then the output will be 7. Because, 7 rows are there in the range D3 to D9. Thats how column function also works.
How can we create sequence of numbers using Rows function? For that you need to be aware of the concept Absolute and Relative reference, Expandable range. That we will discuss in the next post.
Comments