2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula or function for tracking change over time

I am working on a spreadsheet that projects class need and usage over a 4 year period. The top row of my chart tracks how many students are able to enroll each month. I project these enrollments a year at a time then duplicate the numbers for the next 3 years (i.e January is 6, February is 0, March is 4, April is 2, May is 4 and so on).

Students graduate in 5 months. This is tracked in the second line. So January enrollment of 6 and makes a May graduation 6. The third line tracks students in the program in any given month. So if there were 0 before January, and January had 6 enrollments line three would be 6 for January, 6 for February, 10 for March, 12 for April and May would be 10 (6 added/6 graduated).

Is there a way to automate the calculation for the third line? I feel like this should be simple but I can’t quite figure it out.

Editing for relevant info:

I’m online, on a laptop using windows. I’m using Microsoft Office LTSC Professional Plus 2024.

submitted by /u/Crazy_Stay4392
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#real-time data collaboration
#real-time collaboration
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#row zero
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration