COUNTIF is not giving exact value

[Siddhu300]

Hi Friends,

I am facing a problem, I have written a formula =COUNTIF(homel!$A$2:$C$63830,@$A$2:$A$3820) to compare data in two column in two different sheets.

This formula is giving the value 1 for XCYZ when it is finding XCYZ.ccy.com.

I just want that it should throw 0 for such situation. Please let me know what modification should I do with the formula.

Thanks

[#2]

@Siddhu300 Are you sure? It should not. But why not use:

=COUNTIF(homel!$A$2:$C$63830,A2) 

and copy it down.

It makes no sense (to me at least) to use  @$A$2:$A$3820 as you still have to copy it down. If your Excel version can cope with dynamic arrays, you can omit the @-sign and the results will spill down to 3819 cells in one go.

[#3]

Thanks for the suggestion but my problem is not that. It is counting the partial result also which is not required.
Do you have solution for that?

[#4]

@Siddhu300 No I don't, but can you upload an example file with only a few rows demonstrating the "error"? No need to include all 68000 rows.