Knowledge Base

Answers and Guides

What is the difference between combinations and permutations in Excel?

Combinations and permutations both count how many ways you can choose items from a group, but they answer different questions. Pe…

What does the UNIQUE function do in Excel?

The UNIQUE function extracts the distinct values from a range or array and returns them as a dynamic array. It removes duplicates…

How to Count Birthdays by Year in Excel

Use a formula that tests the year of each birthday and counts the matches. Exceljet's featured example does this with SUMPRODUCT …

What kinds of Excel tutorials and resources does Exceljet offer?

Exceljet is a learning site for Microsoft Excel built around short, example-driven material: formula walkthroughs, bite-sized vid…

What Is Exceljet?

Exceljet is an online learning resource for Excel users who want to work faster in the program. It combines short videos, worked …