by Crispo Mwangi | Apr 28, 2022 | ADVANCED EXCEL
Having a dynamic training calendar is a MUST for all HR professionals. How it Works: Type the below formula on the Calendar sheet. =IFERROR( TEXT( INDEX(trainings[[Date From]:[Date From]], MATCH(TRUE,(NOT(ISBLANK(trainings[[Date From]:[Date...
by Crispo Mwangi | Dec 26, 2021 | ADVANCED EXCEL
Though not a popular dynamic array function, there are many ways to use the RANDARRAY function in Excel. How come the RANDARRAY function did not and does not get as much fuss. Is it important to learn it? Even when the excel experts were asked to vote for their...
by Crispo Mwangi | Oct 16, 2021 | ADVANCED 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 the FILTER function? Is it the future of Lookup functions? Here are 24...
by Crispo Mwangi | May 14, 2020 | ADVANCED EXCEL
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”,...
by Crispo Mwangi | Aug 4, 2018 | ADVANCED EXCEL, INTERMEDIATE EXCEL
Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how to lookup unique values is very important. This article shows 5 ways to tackle duplicate data menace and create a dynamic lookup table with unique values. The task is to...
by Crispo Mwangi | Aug 12, 2017 | ADVANCED EXCEL
When was the last time you comprehensively looked at the HLOOKUP function and its alternative? To look up data horizontally, many excel users tend to use HLOOKUP but it has its limitations. So what are the alternatives? In this article,...
Recent Comments