SMALL/LARGE function

Hi all,

I have a working array like :

=IF(COUNTIF(SalesmanList!$A$2:$A$200,A2)>1,(LARGE((SalesmanList!$A$2:$A$200=$A2)*(SalesmanList!$I$2:$I$200),4)),0)

and I now want to count the nth smallest sale instead of largest but get a "0.0" result when I swap the SMALL and LARGE functions in this array. Any clues what the problem might be or perhaps an alternative way of doing this?

Also when using SMALL I don't want to count zero values - would I best do this by including an "AND <> 0" function with the COUNTIF function, and how?

Thanks in advance for any help.

Barry

Try...

=IF(COUNTIF(SalesmanList!$A$2:$A$200,$A2)>1,SMALL(IF((SalesmanList!$A$2:$A$200=$A2)*(SalesmanList!$I$2:$I$200>0),SalesmanList!$I$2:$I$200),4),0)

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!