20 WAYS TO USE FILTER Function EXCEL

20 WAYS TO USE FILTER Function EXCEL

Apart from XLOOKUP, the other dynamic array function that gets too much publicity is FILTER Function. 29 Excel Experts ranks it as the 3rd most important function to learn. Why all the fuss with FILTER function? Is it the future of Lookup functions? Here are 20 things...
Find and Replace ANYTHING in Excel

Find and Replace ANYTHING in Excel

Data cleaning takes up to 80% of the time for a data analyst. To save time use the below tricks to clean mixed digits and letters in a string Find and Replace ALL Numbers in Excel Given below data, find and replace all number digits NB: the Trick is using the...
Extracting the Last Word In Excel

Extracting the Last Word In Excel

Assume you have below data and you need to get the last name as Surname & the rest as Other Names. If only One name exists extract it as the Surname. Here are the Steps to follow: Find the position of the last word in the name.To do this you need to count the...
WTF with XLOOKUP Function

WTF with XLOOKUP Function

NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it “Functions Killer”, “Ultimate Lookup Function”, “Single Most Important function”,...

Pin It on Pinterest