Forum Discussion
Fill series with a Filter Applied
Attempting, to drag and fill a series (1,2,3,4) down a column with a filter applied. I filtered out all the female cast, then attempted to enter "1" into E2, then "2" into E3, then drag ...
Select E2 and E3, then drag it down.
source> How to Auto Generate Number Sequence in Excel (9 Examples)
Thanks Method 1 and 2 is what I am used to doing. Never had to use a formula like methods 3-9 in the link you gave. There is no mention of if there are filters applied. I am thinking something was changed or a potential bug.