# Counting matches between 2 columns

Options

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?

## Best Answers

• ✭✭✭✭✭✭
Answer ✓
Options

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)

• ✭✭✭✭✭
edited 10/07/22 Answer ✓
Options

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?

## Answers

• ✭✭✭✭✭✭
Answer ✓
Options

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)

• ✭✭✭✭✭
edited 10/07/22 Answer ✓
Options

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?

• Options

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

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!