Help counting duplicaes in a column but not blanks

Options

Hello, I want to count duplicates in a column but not count blanks. Any assistance appreciated. Az


This formula works but it counts the blank cells

=COUNTIF([Name (Last, First)]:[Name (Last, First)], [Name (Last, First)]@row)


This formula results in all '1's but doesn't count blanks.

=IF(COUNTIFS([Name (Last, First)]:[Name (Last, First)], [Name (Last, First)]@row, [Name (Last, First)]:[Name (Last, First)], NOT(ISBLANK(@cell))) > 1, 1)

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    =COUNTIFS([Name (Last, First)]:[Name (Last, First)], [Name (Last, First)]@row, [Name (Last, First)]:[Name (Last, First)], NOT(ISBLANK(@cell)))

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    =COUNTIFS([Name (Last, First)]:[Name (Last, First)], [Name (Last, First)]@row, [Name (Last, First)]:[Name (Last, First)], NOT(ISBLANK(@cell)))

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!