This simple formula will show if there is another duplicate value.

=IF(COUNTIF($A$2:$A$8, $A2)>1, "Duplicate", "")
Source
https://www.ablebits.com/office-addins-blog/2016/03/02/identify-duplicates-excel/

Categorized in:

Excel,

Last Update: May 18, 2024