Return number of unique values based on values in other column

**Medir** · 11-26-2013, 11:10 AM

Hi all,

I have a problem and maybe you guys can provide some help. The attachment shows a sample of the data I am working with.

I need a formula that returns the number of different dates for a certain stock in a certain year. I have used

=SUM(IF(FREQUENCY($C$3:$C$32,$C$3:$C$32)>0,1)) and this gets me the unique values across the whole data set and I have tried other array formulas to try to filter it for a certain stock in a certain year but I cant get it to work.

Any suggestions would be welcome

Thanks

Medir data.xlsx

**Tony Valko** · 11-26-2013, 11:17 AM

Try it like this...

Array entered**:

=SUM(IF(FREQUENCY(IF(A$3:A$32=A3,IF(YEAR(C$3:C$32)=B3,C$3:C$32)),C$3:C$32),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Return number of unique values based on values in other column

LinkBack

Thread Tools

Rate This Thread

Display

Return number of unique values based on values in other column

Re: Return number of unique values based on values in other column

Thread Information

Users Browsing this Thread

Similar Threads

Number of unique values in column A based on values in columns B and C

[SOLVED] Return unique values based on another column's value

Sum values in one column based on unique values in another

Find unique value in column and return multiple values

Look across values in 12 columns, return the number of unique values

Bookmarks

Bookmarks

Posting Permissions