Help counting duplicaes in a column but not blanks

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
-
=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
-
=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
Categories
Check out the Formula Handbook template!