Validate "All duplicate values" list (D2:D7)
Array formula in E13:
Validate "Values having duplicates" list (F3:F4)
Array formula in E17:
What is named ranges?
How to implement array formula to your workbook
Change the named ranges.
Download excel file for this tutorial.
(Excel 97-2003 Workbook *.xls)
Functions in this article:
Counts the number of cells within a range that meet the given condition
Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE