Counting matches between 2 columns

I am trying to see which customer numbers repeat from one week to the next.

I have a column for last week, then one for this week with client #'s and this formula to look for matches.

=MATCH([10.7.22]@row, [9.30.22]:[9.30.22])

From the image, clearly there are numbers in 10.7 week that are in week 9.30, but coming up as #No Match (Highlighted in matching colors to show they are indeed in 9.30 column)

Is there a different was to get this accomplished?

Screenshot 2022-10-06 165319.jpg

Find more posts tagged with

Accepted answers

Paul Newcome

Try using the thrid portion of the MATCH function to specify an exact match:

=MATCH([10.7.22]@row, [9.30.22]:[9.30.22], 0)

Michael Culley

I believe what you want to use is a countif formula

=countif([9.30.22]:[9.30.22],[10.7.22]@row)

Or are you trying to find the row number where it matches?

All comments

Paul Newcome

Try using the thrid portion of the MATCH function to specify an exact match:

=MATCH([10.7.22]@row, [9.30.22]:[9.30.22], 0)

Michael Culley

I believe what you want to use is a countif formula

=countif([9.30.22]:[9.30.22],[10.7.22]@row)

Or are you trying to find the row number where it matches?

Connie Torres

Thanks to you both. These will get me to my goal.

Paul Newcome

Happy to help. 👍️

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.