•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to extend formula beyond first 20 rows in a particular column
Our take
If you're looking to extend a formula beyond the first 20 rows in your spreadsheet, you've come to the right place. It's not a dumb question at all—many users encounter similar challenges when working with dynamic calculations like age based on birthdays. Fortunately, there are straightforward methods to ensure your formula applies to all relevant rows. Let’s explore how to easily update your formula so it can calculate age for every entry in your column, empowering you to maximize your spreadsheet's potential.
I have one column in a spreadsheet that calculates age based on birthdays. But it stops at row 20. I need to to go beyond that. How do I do that?
Sorry if it sounds like a dumb question.
ETA: I don’t know how to update flair but this is SOLVED!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience