SMALL – Excel Function

What it does: The SMALL() Function provides the n-th smallest piece of data from an array.

Plain English: The SMALL() Function is similar to MIN(), but what if instead of the smallest piece of data in a set, you wanted the 2nd smallest? Or 10th smallest? You can do it with SMALL()

Arguments: SMALL(array, n)

  • Array – the array of data you want to find the n-th smallest number from
  • n – The position from the smallest that you’d like to generate. I.e. a “2” here would yield the 2nd smallest number.

Blog Posts using SMALL()

  • Article 1

Videos using SMALL()

  • Video 1

LARGE – Excel Function

What it does: The LARGE() Function provides the n-th largest piece of data from an array.

Plain English: The LARGE() Function is similar to MAX(), but what if instead of the largest piece of data in a set, you wanted the 2nd largest? Or 10th largest? You can do it with LARGE().

Arguments: LARGE(array, n)

  • Array – the array of data you want to find the n-th large number from
  • n – The position from the largest that you’d like to generate. I.e. a “3” here would yield the 3rd largest number.

Blog Posts using LARGE()

  • Article 1

Videos using LARGE()

  • Video 1

COUNTIFS – Excel Function

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria.

Plain English: This formula is the logical extension of the COUNTIF() formula. Instead of counting based on one criteria, i.e. “How many cells are TRUE?”, you can count cells based on multiple criteria, i.e. “TRUE, Greater than 100, within 2017”

Arguments: DATE(criteria_range 1, criteria, [criteria_range 2], [criteria])

  • Criteria_range 1 – What is the range where you want to search for the first criteria?
  • Criteria 1 – What is the criteria within the first range?
  • Criteria_range 2 – optional – What is the range where you want to search for the second criteria?
  • Criteria 2 – optional – What is the criteria within the second range?

Blog Posts using COUNTIFS()

Videos using COUNTIFS()

  • Video 1