Forum Discussion
Fill series with a Filter Applied
- 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.
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 🙂
I think the "way to explain this" is that Microsoft has not been able to keep up with Google Sheets. In google, I can filter to my hearts content. I can then add a colum. I can create a series in the first 2 rows of my results. It can use letters and numbers, e.g., D.001, D.002. I can then higlight those two, drag, and the rest of the cells will be in sequence: D.003, D.004, D.005, etc.
I don't need to write formulas and jump through hoops to do some pretty quick stuff that helps a non-technical person present data pretty quickly to other non technical people in a collaborative spreadsheet.
I also don't see any AI integration yet, where I could just ask excel to populate column B. with a sequence based on a pattern and just to rows that I've filtered. I think that would be a great alternative.
Probably like many others, I've gone through mergers, and my company is back OFF of drive and only uses excel, so, thanks for the 'how tos,' cause I appreciate the options. I'd appreciate it more if excel & sharepoint were as easy to use for myself and for collaboration as google sheets and drive.
