# Counting unique values from data on TWO separate excel tabs

1. ## Counting unique values from data on TWO separate excel tabs

Hi everyone,

In the attached file, the problem is listed on Tab 1.

I just need to find a way to count unique values but using a formula that would look up data in both tabs at the same time. The correct answer is provided in Tab 1. Can someone enter the required formula in the two highlighted yellow cells?

Thanks!

2. ## Re: Counting unique values from data on TWO separate excel tabs

Attached does this.

I had to create helper columns to do this. in the first tab i've joined A B C and D columns together as one string. In the next column I can check each row to see if the string exists in the previous rows. If yes then it is left blank, if not it joins A B and C together (ABC together will be used later). Then in Tab 2 i've done the same again but the fomula first checks tab 1 then tab 2 to decide if this row is a unique occurence.

Then you can use a formula to count the number of times A B anc C joined together occur (ie. IA BB 2013 is searched for in Col F but joined together to become IABB2013) in the same in tab 2 and add these together to get your result.

3. ## Re: Counting unique values from data on TWO separate excel tabs

Hello,

Check if the attached file is what you are expecting.

I literally made 3 array formula for each case: counting unique in tab 1, counting unique in tab 2, sum them together then minus the duplicated in both tab. There is no helper column.

4. ## Re: Counting unique values from data on TWO separate excel tabs

Thanks Harribone, your formula solved the issue!

5. ## Re: Counting unique values from data on TWO separate excel tabs

Thanks Lemice, your suggestion works as well, and it also gives me something to learn further (arrays).

I'll mark this thread as solved.

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