Highlighting Duplicate Values in Excel - adding alerts with Dynamic Array Formulas
Identifying and preventing unnoticed duplicates in your data can be extremely important in building robust, error free reports.
Iván made a goof point in the comments re data validation:
To prevent new duplicates being added at the bottom of the table I would name my range of cells in my table as MyList and then use =MAX( COUNTIF( MyList, MyList) ) =1
Here's a link to the file I created
https://aasolutions.sharepoint.com/:f...
Follow me on LinkedIn
/ wynhopkins
Twitter
/ wynhopkins
Access Analytic Training
https://accessanalytic.com.au/training