# Count unique values based multiple criterias

1. ## Count unique values based multiple criterias

Hi
i have trouble to get a formula to count unique values based on multiple criteria

I get it this formula to work
``Please Login or Register  to view this content.``
If the data looks like this:

1022-26, 2014-01-01
1022-26, 2014-01-01
1022-26, 2014-01-02
1022-26, 2014-01-02

It will count the unique value correct to 2.

But how do i add another criteria (for FM) ?

FM, 1022-26, 2014-01-01
FM, 1022-26, 2014-01-01
FM, 1022-26, 2014-01-01
FM, 1022-26, 2014-01-02
FM, 1022-26, 2014-01-02

This should also results in 2.

sample workbook: test.xlsx

Best regards Petter

2. ## Re: Count unique values based multiple criterias

=SUM(IF(FREQUENCY(IF(\$G\$2:\$G\$1000<>"",IF(INDEX(\$C\$2:\$C\$1000&\$A\$2:\$A\$1000, 0)=R2&Q2,MATCH("~"&\$G\$2:\$G\$1000&"",\$G\$2:\$G\$1000&"",))),ROW(\$G\$2:\$G\$1000)-ROW(\$G\$2)+1),1))

3. ## Re: Count unique values based multiple criterias

Thank you it works fine

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