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?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!