Скачать или смотреть How to Count Unique Items on a Menu

This Excel video is designed for advanced users who want to efficiently count unique items in a list while ignoring duplicates.

The video teaches you how to use complex formulas like FREQUENCY, MATCH, ROW, and SUMPRODUCT to achieve this. These formulas help you count the number of different items in a menu, like unique food items, even if they appear multiple times, without counting duplicates.

The video also introduces a simpler method using the COUNTIF function but explains that it might be slower for larger datasets. It dives into the technical details of how these formulas work, like converting non-numeric data into numeric data for calculations, finding positions of items, and generating sequential lists.

The video even covers handling empty cells in the list.

EXCEL PRIMED RECOMMENDED COURSES

**Excel Essentials - The A-Z Guide for Advanced Users:
https://excelprimed.com/courses/excel...

**Excel Essentials - The A-Z Guide for Beginners Level I:
https://excelprimed.com/courses/excel...

**Excel Essentials - The A-Z Guide for Beginners Level II:
https://excelprimed.com/courses/excel...

**Excel Essentials - The A-Z Guide for Intermediate Users:
https://excelprimed.com/courses/excel...

**Excel Formulas - Advanced Level I:
https://excelprimed.com/courses/excel...

**Excel Formulas - Advanced Level II:
https://excelprimed.com/courses/excel...

**Excel Formulas - Beginners Level I:
https://excelprimed.com/courses/excel...

**Excel Formulas - Beginners Level II:
https://excelprimed.com/courses/excel...

**Excel Formulas - Intermediate Level I:
https://excelprimed.com/courses/excel...

**Excel Formulas - Intermediate Level II:
https://excelprimed.com/courses/excel...

**Excel Data & Text Manipulation - Advanced Users:
https://excelprimed.com/courses/excel...

**Excel Data & Text Manipulation - Beginners:
https://excelprimed.com/courses/excel...

**Excel Data & Text Manipulation - Intermediate Users:
https://excelprimed.com/courses/excel...