Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1793.xlsx
Learn how to determine if there are duplicates in a row.
Topics:
1. (00:00) Introduction
2. (00:09) Logical Formula to indicate if duplicates are in row. OR and COUNTIFS functions.
3. (03:02) Conditional Formatting to indicate if duplicates are in row. COUNTIFS function.
4. (05:54) Count Unique Items with UNIQUE and COLUMNS functions.
5. (06:45) Logical Formula to indicate if duplicates are in row. COLUMNS and UNIQUE functions.
6. (07:29) Count Unique Items with FREQUENCY, MATCH, COLUMN and SUM functions. Old School Formula.
7. (07:59) Summary
8. (08:20) Closing, Video Links

ExcelIsFunTue, June 14, 2022 5:38pm