Microsoft Excel Tutorial: Reducing a 75-Minute Excel Process to 9 Seconds | Microsoft Excel Solution.
Microsoft Excel Solution: Reduce a 75-Minute Process to 9 Seconds.
Welcome to this episode where we take a 75 minute manual process and reduce it to just 13 or 9 seconds. Shout out to all my friends who contributed to this video long ago, but due to Hurricane Ian, we were unable to publish it. But now, a month later, everything is back to normal and I wanted to share this amazing solution with you all. So thank you to everyone who sent in their ideas and videos, and apologies for the delay.
It all started with an email from a viewer who was struggling with a tedious task of inserting a row after every two rows in a dataset of 4,000 rows. This would take about 75 minutes of manual work, which is definitely not fun. So I turned on the video recorder and in just 1 minute and 58 seconds, I solved the problem for 200 rows of data. But then, I received a complaint on social media that the solution was too slow and had too many steps. This got me thinking, maybe I should formalize this and make it faster.
So I reached out to some of the fastest people in Excel and asked for their input. Peter_SSs from the MrExcel board pointed out that my method was wasting two steps and came up with a faster solution. Anup Agarwal, a competitor on ESPN, also shared his method which was even faster at 14 seconds. But the fastest solution came from Diarmuid Early, who is known as the fastest guy in Excel. He explained the whole process in just 57 seconds, but the actual solution took only 13 seconds. And just when I thought it couldn't get any faster, Diarmuid came up with another method that reduced the process to just 9 seconds.
But the real challenge with these types of questions on YouTube is that we can't see the person's computer or spreadsheet. So we have to be prepared for the worst and consider all possible scenarios. Diarmuid pointed out that there could be formula dependencies between each group of two rows, which would make most of the solutions proposed by others invalid. However, the method suggested by Peter_SSs and Anup using Go-To Special, Blanks, and Insert Rows, was the fastest and also preserved the links between each individual group.
I want to thank all my friends who are the fastest people in Excel for their amazing and elegant solutions. And I also want to thank you for watching and being a part of this community. Don't forget to like, share, and subscribe for more helpful Excel tips and tricks. And if you have any suggestions or questions, please leave them in the comments below. Until next time, this is Bill Jelen from MrExcel, signing off.
Buy Bill Jelen's latest Excel book: [ Ссылка ]
You can help my channel by clicking Like or commenting below: [ Ссылка ]
Table of Contents
(0:00) Hurricane Ian delay
(0:34) 2-minute solution for OP
(1:11) 53-Second solution
(1:30) Too Slow
(2:10) Fastest Excellers
(2:30) Anup Agarwal
(3:07) Diarmuid Early I
(4:06) Diarmuid Early II
(4:35) Imagining OP data
(4:52) Other solutions
(5:09) Formula dependencies between rows
(5:20) Anup / Peter solution
(6:22) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
75 minutes of work
Anup Agarwal's method
Diarmuid's method
Excel shortcuts
Fastest way to insert rows
Formula dependencies in Excel
Go To Special function
Insert row after every two rows
Manual process
Peter_SSs' method
Preserving links between rows
Join the MrExcel Message Board discussion about this video at [ Ссылка ]
In this video, several of my friends and I propose ways to cut a 75-minute Excel process down to under 15 seconds. As expected Diarmuid Early posts the fastest time with an under-10-second solution. But Diarmuid warns about a possible problem in the data, which makes a method proposed by Peter_SSs and Anup Agarwall the fastest and safest method.
The formula methods from others:
[ Ссылка ]
[ Ссылка ]
