"Matching" formula whose lookup array changes depending on another column

[469]

Store 1 Address 1
Store 1 Address 2
Store 1 Address 3
Store 1 Address 4
Store 1 Address 5
Store 2 Address 6
Store 2 Address 7
Store 2 Address 8
Store 3 Address 9
Store 3 Address 10
Store 3 Address 11
Store 3 Address 12
Store 3 Address 13
Store 3 Address 14
Store 3 Address 15

I have the above table and would like to run a matching formula for the addresses column, for each specific store. I want to determine if any of the 5 addresses for "Store 1" match each other, and the same for the other stores. I can't figure out how to do it, since there are not the same number of addresses for each store.

[Pete_UK]

Assuming your data is in columns A and B, starting in cell A2 to allow for headers, then you can put this formula in cell C2:

=COUNTIFS(A:A,A2,B:B,B2)

Then you can copy this down to the bottom of your data. If there are no duplicates, the formula should return 1, so if you have any numbers above 1 this means that you have duplicates.

Hope this helps.

Pete