Finding duplicates numbers

edited 12/09/19 in Formulas and Functions

I have been trying to build a formula that will find duplicate numbers. Most solutions that I found in the community will only work for text. Can anyone help with finding what I'm doing wrong. The formula shown on my screenshot is the same the entire column. Cells highlighted yellow should show as a duplicate.



Duplicate Numbers.JPG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!