>
> Hello Chandru,
Fiirst of all, I am not sure where is these conditions in the sample, you
provided. (a1:a5>=1)*(a1:a5<=4). I only can see two columns in the sample.
ColA: 10;20;30;40;50. ColB 100;200;300;400;500.
Anyway, you can use ISNA(MATCH or COUNTIF to check LIST 2 is NOT contains
i
Hi Chandru,
Yes, you are correct some product always work on equal size of range.
regards
Prince
On Monday, October 15, 2012 6:21:12 AM UTC+1, Chandru wrote:
>
> hi Group Member
>
> i have small doubt how to use Sumproduct Not Equal Rangelike
>A B
> 110100
>
Hi
Can you please share sheet with results required by you.
Prima facie you are getting array because you are comparing range of not
same size.
Rgds//Vabs
On Monday, October 15, 2012 10:51:12 AM UTC+5:30, Chandru wrote:
> hi Group Member
>
> i have small doubt how to use Sumproduct
