Pls suggest...

[Ajinkya]

Hi,


I have a sales person names in cell range B3:B10 and his customer list in cell range C3:C10.

from the sales person names any ones name is in the cell B12, I want his uniqe customer's total count in the cell C12


hence im trying to use formula as per below,

=MATCH(B3:B10,B12)*(SUMPRODUCT(1/COUNTIF(C3:C10,C3:C10)))


but the problem is output is not coming, please suggest….

 

[Faseeh]

Hi Ajinkya,


Use this:

=SUM(IF(FREQUENCY(IF(A$1:A$7=E2,MATCH(B$1:B$7,B$1:B$7,0)),ROW(B$1:B$7)-ROW(B$1)+1),1))

[Ctrl+Shift+Enter]


See this file:

http://dl.dropbox.com/u/60644346/Ajinkya_Unique%20Values.xlsx


Regards,

Faseeh

 

[Ajinkya]

Done, Faseeh, thanks dear.....