Count Unique Values

[TerriC1984]

Help please...I want to count the number of unique values in Column B (delivery postcode) where column I is a specific value (delivery depot) eg how many postcodes did a specific depot deliver to.
I've tried multiple variations of countif, frequency, match etc but can't seem to get it right Does anybody have any suggestions?
Thank you
Terri

 

[Tom.Jones]

Need more info, but try:

=SUM(IF($I$2:$I$15=specific value, (1/COUNTIFS(B2:B15;B2,B15,I2:I15;"="&specific value)); 0))


This is CSE formula.

 

[TerriC1984]

Thank you...it still doesn't like it. I can give you as much info as you need to help...I'm baffled myself!

 

[Fluff]

Have a look here
https://exceljet.net/formula/count-unique-text-values-with-criteria

 

[Tom.Jones]

...it still doesn't like it.

In what way?

I can give you as much info as you need to help

Not. It is not enough!!.
Whether column B has empty cells or not. The formula is different ...
Whether column I has empty cells or not. The formula is different ... What kind of data are in text columns or numbers? The formula is different ...

I tried to help you ...

 

[Fazza]

hi, Terri. depending on what you're doing, a pivot table or query might be good too. regards

 

[TerriC1984]

Sorry, I wasn't being rude, I really appreciate your help. I meant what else would you need to know? I'm happy to share whatever I can for you to help me but don't know what you might need. This is way beyond my Excel ability and even my Google skills are failing me...I'm baffled by the formula not your request for more info.
Both columns B and I have blank cells.

 

[Fluff]

Can you supply some sample data?
There are add-ins available here that enable you to include data in a post. Add-ins