Forum Discussion

ktemplin's avatar
ktemplin
Copper Contributor
Sep 03, 2024

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 ...
excel
templintek's avatar
templintek
Copper Contributor
Sep 04, 2024
What I may have to do to manually get around this. But it will be manual PitA as the real sheet I have has thousands of rows I have to contend with.
Lorenzo's avatar
Lorenzo
Silver Contributor
Sep 04, 2024

templintek 

 

What I may have to do to manually get around this. But it will be manual PitA as the real sheet I have has thousands of rows I have to contend with

There are probably many ways to get what you expect but without the complete picture not sure how to help you with this. If this can help.... In attached file you'll see:

 

The Blue Table contains data to be ranked (your wording). The Rank column contains formula for Excel 2021/365. The Excel Legacy column contains formula for previous versions

 

The Black Table is referenced by the above formulas to indicate the Starting number of the Ranking by Sex

 

If you run Excel >/= 2016 on Windows or 365 on Mac, there's probably a way to get things done with Power Query....

 

Sharing a sample file + the actual expected result would help to help you 🙂