Count unique values in one column given multiple criteria for other columns

**scottylad2** · 05-26-2011, 11:29 AM

I can't see how you could do it without introducing a helper column. My attempt would be to list the items that meet your criteria in a column, I've used column F which has an array formula to pull through all values that meet the criteria, then in column G a count of the unique. Is this close to what you need? I had already made up my sample before you posted, i'm sure you can adapt to meet your layout. If it's just the count you need then you can hide column F

I've added some CF to make it easier to look at

**redraishes** · 05-26-2011, 12:58 PM

Scotty,

Thanks for the reply. That is exactly what I want, except without the helper column.

I had a similar request a bit back, here is the URL: http://www.excelforum.com/excel-gene...e-columns.html

Similarly to now, I was looking for a way to count unique entities in one column based on requirements being met in other columns. The difference is that I now need the function to check an additional column for values NOT equal to some criterion.

What you did is exactly what I asked for. I apologize for not specifying that I cannot use a helper column.

Thanks.

Count unique values in one column given multiple criteria for other columns

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Count unique values in one column given multiple criteria for other columns

Re: Count unique values in one column given multiple criteria for other columns

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions