How do I write a formula that only finds unique or duplicate text from a single column?
I have a sheet with 7,195 rows of data. I'm trying to write a formula that looks in the "Full Name" column to find which names are unique and which are duplicates. Any suggestions?
I've tried this formula:
=IF(Countif([Full Name]1:[Full Name]7195, 1)
I also thought using the DISTINCT function may help, but I'm not sure.
Help Article Resources
Check out the Formula Handbook template!