How to count duplicate Names as 1

I just need help on how to count duplicate names into 1 count vs total number of names. If duplicate just count as 1. Can you help please?

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭

    To be sure I am understanding the question You are wanting Allison to be counted as 4? OR are you wanting it to flag with a 1 if the name is duplicated? If the first Try this formula.

    =COUNTIFS(Name:Name, Name@row)

    If the second you can use that same formula with in an IF function.

    =IF(COUNTIFS(Name:Name, Name@row) > 1, 1)

    Column 2 uses the first formula, Column 3 the second.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • I'm doing a data Report just need to count how many people have no show/out within this year not how many times they no show/out. I have the formula for that. I just need how many people who missed/no show. So for Alison who no show 4x I just need to count her as 1. Hopefully this is helpful explained. Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!