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 ...
I think Fill Series does not work directly on filtered data. Try this approach then,
Original Table:
Use this formula for your 'Rank' column(D2) then drag the formula to bottom:
=SUBTOTAL(3,$A$2:A2)
When you filter your table based on Gender (Let's pick "Female) and Sort the episodes from Highest to lowest.
Using a formula, it will account the visible cells only. so SUBTOTAL function creates a sequence that updates correctly when filters are applied.
If you want to save those Ranks filtered data, you need to copy paste it to another cell or sheet.