proficient
Well-known Member
- Joined
- Apr 10, 2012
- Messages
- 745
- Office Version
- 2016
- Platform
- Windows
- Mobile
Easiest way is to use Advanced Filter to generate a separate list of unique values, have a read of:
How to remove duplicate records or create list of unique records in Excel
Try this in Column B2 (Assuming First Row will be header) and drag down
=IF(COUNTIF($A$1:A2,A2)>1,"Duplicate","Unique")
Try this in Column B2 (Assuming First Row will be header) and drag down
=IF(COUNTIF($A$1:A2,A2)>1,"Duplicate","Unique")