# Formula that counts duplicates on a separate tab

1. ## Formula that counts duplicates on a separate tab

Good morning!

Is there any way to have the formula in cell B3 on the USE tab count the duplicates that exist within columns B and C on the SITES tab, depending on what value is in cell B1 on the USE tab?

Essentially a formula that provides the answer to: Whatever value exists in tab USE: cell B1, count duplicates within tab SITES: columns B and C which consist of that value.

2. ## Re: Formula that counts duplicates on a separate tab

A formula that doesn't work.... one point. An expected answer, calculated maually, 10 points.

So... a guess:

=COUNTA(FILTER(SITES!B2:B26,SITES!B2:B26=USE!B1))

3. ## Re: Formula that counts duplicates on a separate tab

Ok, edited.

So the formula is supposed to count the duplicate addresses in column C, that correspond with the city in column B. Can that be done?

For instance:

Oakland 150 is listed 4 times. This should be 4 of the duplicates counted.

4. ## Re: Formula that counts duplicates on a separate tab

This: "Oakland 150 is listed 4 times. This should be 4 of the duplicates counted." does not tell me if 4 is the final answer... or part of the final answer....

5. ## Re: Formula that counts duplicates on a separate tab

just for fun with Power Query

6. ## Re: Formula that counts duplicates on a separate tab

Thank you. I'll try to read up on this particular problem. I need to educate myself. Thanks again.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1