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
Tag: excel
Using the Powerful and Function in Excel
Microsoft Excel Tips and Tricks Learn how to use the powerful AND function in Excel to perform logical tests on[…]
Read more
How to Fix Excel Formulas that are Not Calculating or Updating
Microsoft Excel Tips and Tricks In this video, we look at the calculation options in Excel. When the setting gets[…]
Read more
3 EASY Ways to Find and Remove Duplicates in Excel
Microsoft Excel Tips and Tricks These are 3 easy ways to remove duplicates in your data to create a unique[…]
Read more
How to Get a Unique List from Many Columns Using Flatten in Google Sheets
Microsoft Excel Tips and Tricks Getting a Unique List from values in multiple columns can actually be quite hard. An[…]
Read more