Insert Blank Rows with Formula by adding EVEN & UNEVEN rows
HTML-код
- Опубликовано: 5 авг 2024
- In this video, we will learn how to insert blank or empty rows using the excel new calculation engine with using the formula in Microsoft Excel. We might need to insert blank rows after data is entered. This dynamic arrays formula will be helpful in exploring the easy solution to add empty rows after every data.
⏱ Time Stamp
00:00 Intro
00:20 Understanding the dataset & building the solution
01:00 Doing the Math
05:50 Removing the formula
06:30 End Screen
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums/
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
www.meetup.com/saudi-arabia-m...
--------------------------------------------------------------
👍🏻 Like Facebook Page :
/ excelexciting
👥Join The Facebook Group -
/ excelexciting
***********************************************************
You can check the following videos as well
VLOOKUP Data From Multiple Worksheets [Excel for mac & windows]
• VLOOKUP Data from Mult...
Trick to Create A Data Entry Table In Power Query for Excel
• Trick to Create A Data...
Change Multiple Value using Array Method [Excel for Mac & Windows]
• Change Multiple Value ...
Extract Number & Text from a Cell in Excel | Solution 02 by Power Query
• Extract Number & Text ...
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Hi Faraz. Very clever! Thanks for sharing :)) Thumbs up!!
Thank you!
@Wayne Edmondson, very very clever! awesome work Faraz !!! 👌👌👌
✅ Really interesting technique Faraz. Great way of distributing data vertically. I've seen alternatives that spread everything evenly, but this has the advantage of being able to set the number of blanks between each item individually - gives the potential for driving the blank row count from elsewhere in the spreadsheet 👍
Oh this is a very interesting topic. I’ll have to see if I can make this even more dynamic using other dynamic arrays as table functionality
Great tutorial as usual
thank you buddy ....
Very useful information and simple trick
Thank you
Thanks for sharing
god bless you always
Thank you 😊
Awesome
yeah!!