Count How Many Times a Value Appears in the Column

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.

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.