Count Unique Values based on another column

**Ineedhelp12** · 07-02-2009, 12:58 PM

Hi

I am new to this Forum and hope somebody can help me. I need to count unique values based on another column example below

Code Type
N1234 NTU
N1234 NTU
N1234 BYU
N1234 BYU
N6789 NTU
N8974 BYT
B8974 BYT

Code and type vary - I want to count the unique codes based on the type so for instance they would be 2 N1234 and not 4 because they are two types present.

Can anybody help

**DonkeyOte** · 07-02-2009, 01:10 PM

Assuming your data were in A2:B7, in C1 you have N1234

D1: =SUMPRODUCT(--(A2:A7=C1),1/COUNTIFS(A2:A7,A2:A7,B2:B7,B2:B7))

The above utilises COUNTIFS which is not compatible with versions of XL pre XL2007.

**contaminated** · 07-02-2009, 06:12 PM

Another suggection is

Please Login or Register  to view this content.

See attachment.

Count Unique Values based on another column

LinkBack

Thread Tools

Rate This Thread

Display

Count Unique Values based on another column

Re: Count Unique Values based on another column

Re: Count Unique Values based on another column

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions