Count duplicate addresses by frequency of mention

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try something like this...

To get the count of 3 matching addresses...

Data Range

	A	B
1	Name	Address
2	Person1	Address1
3	Person2	Address1
4	Person3	Address1
5	Person1	Address2
6	Person1	Address3
7	Person2	Address3
8	Person3	Address3

This array formula**:

=SUM(IF(FREQUENCY(MATCH(B2:B8,B2:B8,0),ROW(B2:B8)-ROW(B2)+1)=3,1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Result = 2

This array formula** entered in D3 and copied down to D7:

=SUM(IF(FREQUENCY(MATCH(D$12:D$27,D$12:D$27,0),ROW(D$12:D$27)-ROW(D$12)+1)=ROWS(D$3:D3),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.