FREE TRAINING CALENDAR IN EXCEL

FREE TRAINING CALENDAR IN 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...
HOW TO SUMIFS EXACT MATCH IN EXCEL

HOW TO SUMIFS EXACT MATCH IN 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...