•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
Our take
If you're looking to streamline your workflow by generating a list of incremental video lengths, you're in the right place. Specifically, you want to create a sequence of two-minute markers up to the total video length, formatted with "|" separators. This can be particularly useful for managing extensive lists of video lengths, as it eliminates the need for manual entry. By leveraging a formula, you can efficiently automate this task, making it scalable even for thousands of entries. Let’s explore how to achieve this effortlessly.
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]
Read on the original site
Open the publisher's page for the full experience