Unique values from a column based on condition in another

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi,

I want to count the number of unique values in a column
of data where the cell value in the column next to it has
a certain value?

i.e. Count Unique Values In Column B where Column C
= "Apple"

B C
2 Apple
2 Apple
3 Banana
3 Apple

would result in a count of 2.

Any help is highly appreciated.

Thx in advance,

Alan
 
Hi

I want to do exactly the same thing - can anyone help? The lin
suggested by Juan doesn't seem to explain.

Thanks

Emm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to lookup based on a condition of two values 1
Count with two criteria in a second worksheet 1
Why doesn't this work ? 2
Sum of different value in different worksheet & cell number 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Autogroup then sum - can it be done? 5
Count Unique Values in 1 Column based on Date Range in another Column 28
If statement 2

Back
Top