May 06 2021 04:08 AM - edited May 06 2021 04:11 AM
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
May 06 2021 04:26 AM - edited May 06 2021 04:27 AM
@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.
May 06 2021 04:31 AM
May 06 2021 04:40 AM
@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.