Distinct count based on multiple criteria - am I on the right track?

Hi all,

I would appreciate some help if anyone has any idea:

I have the following data:

Column A with TEXT
Column B with TEXT
Column C with a NUMBER

I need a formula that basically matches this criteria:

• Column A = "Person"
• Column B = "Asset"
• Only count distinct values from Column C (these will be ID numbers and I only want duplicates counted once)

Currently I am using this formula/array:

Please Login or Register  to view this content.

But I get a #VALUE error.

Any ideas?

Hi

Try changing it to

Please Login or Register  to view this content.

rylo

It returned a DIV/#0 error.

But after working this out my own way, I realised that it took a while to calculate the array. May look into a VBA macro if that makes it faster. I'll post in another thread.

Try changing the whole column references to actual used ranges.