Here I have got a case where my colleague was working with a project schedule. He had a schedule with a start date, end date, and scope and he had to break up the scope month-wise. With a long schedule, …

Lesson#77: Scope the breakup program schedule and explain the formula Read more »

When you want to get the smallest or the largest number from an array then it’s just using the function MAX and MIN. But if you want to get the Kth largest or Kth smallest then there are more two …

Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest Read more »

COUNTIFS is a function to count those cells within a range which meets multiple criteria.Syntax of the function is COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) criteria_range1 – This is the first range to evaluate. criteria1 – The criteria to be used on criteria_range1. criteria_range2 – …

Lesson#68: COUNTIFS and SUMIFS function in Excel Read more »