Formula to identify the first duplicate record

Formula to look at "Client Name" and if duplicate only return Yes for the first one, if not duplicate then just return Yes but I'm getting an error. Help?

=IF(COUNTIF([Client Name]$1:[Client Name]@row, [Client Name]@row) = 1, "Yes", IF(MIN(COLLECT(ROW([Client Name]$1:[Client Name]@row), [Client Name]$1:[Client Name]@row, @cell = [Client Name]@row)) = ROW([Client Name]@row), "Yes", ""))

Find more posts tagged with

Accepted answers

All comments

heyjay

Not sure what your sheet looks like. And can't provide a complete formula without seeing it. But:

Column references should be something like [Client Name]:[Client Name]
Countif should looks like

=COUNTIF([Client Name]:[Client Name],[Client Name]@row = 1

Connie Cochran

I had used AI to write it at first because I was stumped and that is what it returned. When I removed the $1 sign (it looked weird to me too) I am still getting an unparsable error

What I am looking for is just something to flag every unique name in the Client Name column

=IF(COUNTIF([Client Name]:[Client Name]@row, [Client Name]@row) = 1, "Yes", IF(MIN(COLLECT(ROW([Client Name]:[Client Name]@row), [Client Name]:[Client Name]@row, @cell = [Client Name]@row)) = ROW([Client Name]@row), "Yes", ""))

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.