see if duplicates


is there a way to see if a column has duplicates through an equation when there are 7000 numbers?

Best Answer

  • MichaelTCA
    MichaelTCA ✭✭✭✭✭✭
    Answer ✓

    @Please help You can use a COUNTIF function.

    =COUNTIF([Primary Column]:[Primary Column], [Primary Column]@row)

    This will tell you how many of that cell is contained within the specified range.

    No matter where you are in the list, the result will be the same per duplicate.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!