Duplicates from Excel


Hey Guys!

I am wanting to count duplicates from a dump in Excel for one column (Supplier Id). I know my formula is correct but it seems to not be counting correctly because either 1) the tick mark added to the beginning of the number from Excel or 2) the amount of zeros? Any ideas to fix this?

Formula: =COUNTIFS([Supplier Id]:[Supplier Id], [Supplier Id]@row)

Example of Supplier ID: '000001777 (all have many zeros before some #s)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!