⚡Delete Blank Rows and Columns FAST with the REMOVE Function in Excel.
📽️ In this Microsoft Excel video tutorial I show how to use my REMOVE function to delete empty rows and columns from your data.
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
REMOVE is a custom LAMBDA function which you can use in your workbooks. Just copy and paste the formula into the Name Manager as shown in the video.
=LAMBDA(data,
LET( rawdata,data,
r,NOT(BYROW(ISBLANK(rawdata),AND)),
c,NOT(BYCOL(ISBLANK(rawdata),AND)),
FILTER(FILTER(rawdata,r),c)
)
)
🕰️Timestamps
00:00 Introduction
00:55 Walk through the function with help columns
02:51 Using LET to create a single formula
05:35 Creating the LAMBDA function
06:19 Installing the custom LAMBDA function
#exceltips #exceltricks #exceltutorial