Number series

When using filter lines disappear entirely. If the table has had line numbers, it will be shot down. But, there's a way around this problem.

RANK()the English version RANK(), returns the rank number in list of numbers. The rank of a number is its size relative to other values in the list. For example, in the array {10,20,5} the number 5 will have rank 1, since it is the smallest number, the number of 10 - grade 2 and 20 grade 3 (this is the rank in ascending order, when the smallest value is assigned rank 1). If the list to sort on, the rank number will be its position (if no repeats).

Create a numerical sequence of different types: 1, 2, 3, ... 1, 3, 5, 7, ... I, II, III, IV, .... 100, 200, 300,...00-01, 00-02, ... 1, 1, 1, 2, 2, 2,... etc.

Count the number of consecutive values in the column. Consider a non-repeating series of values (111222234444...) and repetitive (110111000010 and 110221010112).

Due to the feature of the ROMAN() normal line numbers, you can easily convert to the numbering in Roman numerals.

To build array formulas sometimes use a numerical sequence, for example {1:2:3:4:5:6:7}, entered directly into the formula. This sequence can be formed by manually entering the literal array, or using functions such as ROW(). Also using formulas you can dynamically change the length of the numeric sequence.

Find the maximum number of consecutive values in a column. For example, the maximum number of consecutive positive values or odd values or values equal to the specified number.