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 | Apr 11, 2022 | INTERMEDIATE EXCEL
By default, the SUMIFS function is not case-sensitive. To make it case-sensitive and do an exact match, follow the below steps: SUMIFS COMPLETE EXACT MATCH Alternative 1: Using a combination of SUM, IF & EXACT We shall start by doing a complete exact match then a...
Recent Comments