Identifying Duplicates

CAS

Hi I'm trying to work out a formula for identifying duplicates in a invoice column.

what formula would i use and do i setup a separate column to populate the answer to the formula?

my column name is 'Invoice No'

thank you for your assistance.

Find more posts tagged with

Formulas

Accepted answers

All comments

Eric Law

Hello @CAS You will need a new column. You can use this formula,

=COUNTIF([Invoice No]:[Invoice No],[Invoice No]@row)

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.