From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Calculate combinations without duplication

Calculate combinations without duplication - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Calculate combinations without duplication

“

- [Instructor] Elsewhere in this course, I have described how to enumerate the number of possibilities through permutations when the order of things matters. In this movie, I will describe combinations where order doesn't matter. As an example, assume that you have five products and you draw from them to create gift baskets or samples for potential customers. So the question is, if you had five items and you take three and you do not allow duplication, how many possible different combinations do you have? And once again, combinations must occur without duplication. However, in contrast to permutations, order doesn't matter. A gift basket with these three items would be the same as a gift basket with the same items, even if they were put into the basket in a different order. So our goal is to calculate how many unique groups are possible when choosing three to five products without allowing repetition. To demonstrate, I will switch over to Excel. I have opened this movie's Excel sample…

Contents