Identifying Duplicates

I am working on a sheet that contains IP addresses. When reports are added to this sheet, I am currently going through the data and marking any duplicates. I want to find a way to either use conditional formatting to highlight the duplicates or any method that is available.

Is this a possibility without inputting the value that I want to show if there is a duplicate of, since there is no way for me to identify all of the IP addresses?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!