# Number series

### Dynamic row numbering after using Autofilter in MS EXCEL

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.

### EXCEL Functions: RANK

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).

### Generate a Number Series in MS Excel

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 series of values in EXCEL

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

### Number Rows and Columns with Latin Numbers in EXCEL

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

### Array of Consecutive Integers in EXCEL

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.

### Count maximum number of consecutive values in EXCEL

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.