How to use INDEX and MATCH in Excel
INDEX MATCH, when combined, can change the approach you use to lookup values in Excel.Yes, you get it [...]
How to Sum Values Between Two Dates using SUMIFS
How to Sum Values Between Two Dates (SUMIF Between Dates) Yes, you heard it right, using SUMIFS is the [...]
How to use SUMIF with Wildcard Characters in Excel
SUMIF is one of my favorite Excel functions and I’m sure it’s yours also. But one thing [...]
How to Average TOP 5 Values in Excel
Let say you have a line-up of 20 products in your company and you have data for monthly [...]