How to count duplicate Names as 1

Options
valenzuelat
valenzuelat ✭✭
in Formulas and Functions

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?

image.png

· Share on FacebookShare on Twitter

Answers

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

    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)

    image.png

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

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

    · Share on FacebookShare on Twitter
  • valenzuelat
    valenzuelat ✭✭
    Options

    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!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!