Unique values from a column based on condition in another

#1 July 8th, 2004, 08:23 PM

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

#2 July 8th, 2004, 09:00 PM

Hi, visit

http://www.cpearson.com/excel/duplic...CountingUnique

cheers
Juan

-----Original Message-----
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
.

#3 July 16th, 2004, 01:24 PM

Hi

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

Thanks

Emma

---
Message posted from http://www.ExcelForum.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Increment column value based on insert string	Bharnick	Worksheet Functions	0	April 15th, 2004 01:08 PM
Counting items in one column based on another		Worksheet Functions	2	January 15th, 2004 11:01 PM
"Matching" column A's values in column B	Chris.F	Worksheet Functions	0	January 12th, 2004 02:24 PM
Average for condition in different column	Tony R	Worksheet Functions	2	November 21st, 2003 12:01 PM
How do i fill one column based on another?	Debra Dalgleish	Worksheet Functions	3	November 19th, 2003 02:24 PM