Count How Many Times a Value Appears in the Column

Bethany Garcia

I have a column that contains a value (Example: "Joe@email.com:iPhone", "Joe@email.com:iPad"), and I want to have a formula check to see if any value in the column appears more than once, or to just tell me how many times the value in that row appears throughout the column. So in the provided example, if those two values are in the column one time, I would want to see a True or False (depending on whether the formula is indicating that there is or isn't a match), or to see a number indicating how many times that value exists in the column.

Darren Mullen

@Bethany Garcia Yes, that is doable. You'd need to use COUNTIF() or COUNTIFS() and count the number of times the value in a given row appears over the whole column range. You'd then check to see if the resulting value of the count is >1