UNIQUE Formula for Non-Adjacent Columns in Excel
Microsoft Excel we learn how to use a formula to return unique combinations of values from columns that are non-adjacent.[…]
Read more
Category: Excel
When Should you Use the Hash Sign (#) in Excel Formulas?
Microsoft Excel The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference an[…]
Read more
Excel Automatically Replaces Names | Excel Prank Part 3 #shorts
Microsoft Excel In today’s Excel prank you’ll learn how to use autocorrect in Excel (Autocorrect applies to Word, PowerPoint and[…]
Read more
How to Merge Excel Files with Different Headers in Power Query | List.Accumulate
Microsoft Excel Consolidating data from multiple Excel files requires you to have identical table headers otherwise you can run into[…]
Read more
SURPRISING Advanced Filter TRICK in Excel (You’ve Never Heard Of!)
Microsoft Excel With Excel’s Advanced Filter feature you can filter for multiple criteria and copy the filtered results to another[…]
Read more