UNIQUE of Rectangular Range Using MAKEARRAY in Excel
Microsoft Excel Tips and Tricks Another new LAMBDA helper function in Excel is MAKEARRAY. This video shows a simple example,[…]
Read more
Category: Excel
Excel Lambda Now Supports Optional Arguments and ISOMITTED
Microsoft Excel Tips and Tricks You can build Lambda functions in Excel that support optional arguments. A new ISOMITTED function[…]
Read more
Excel Navigation Pane Debuts
Microsoft Excel Tips and Tricks A new navigation pane debuts in Excel. It is a feature for people with low[…]
Read more
Excel Frequency of Combination of Two Columns
Microsoft Excel Tips and Tricks Salama from YouTube has two columns of numbers. The area in column A is from[…]
Read more
Combine First and Last Name in Excel (Using Formulas, Flash Fill, Power Query)
Microsoft Excel Tips and Tricks In this video, I will show you how to combine the first name and the[…]
Read more