Counting matches between 2 columns

Connie Torres

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

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?

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. 👍️