•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pull the value of a cell at a given time
I have a sheet that populates from a Microsoft Form and a statistics sheet that does some calculations based on the responses. I would like to track the value of one of the calculations over time by recording its value every day at midnight but I don’t know how to go about that. I thought about redoing the calculation with only the subset of responses before the specified date but it ends up being very slow
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#real-time data collaboration
#real-time collaboration
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#Microsoft Form
#track value
#statistics sheet
#calculations
#value over time
#responses
#recording value
#data tracking
#specified date
#subset of responses
#excel
#midnight