•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to create a list of increments up until a specified amount
Forgive the title, bit of a difficult thing to describe.
I have a list of video lengths in seconds, and I need to create a list of incremental 2 minute markers up until the video lengh, separated by "|".
Here's an example I created manually:
I need a formula that will enable me to do this at scale as my lists can become several thousand rows deep.
Any help would be greatly appreciated.
EDIT: Forgot to add, there won't be any videos shorter than 8 minutes.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#formula generator
#Excel alternatives
#video lengths
#incremental markers
#2 minute markers
#video length in seconds
#list
#formula
#video duration
#scalable
#rows
#increment
#automation
#time markers
#8 minutes
#manual creation