Hi, i have this code to find duplicates in "sheet2" and "sheet3", but i need
the code to search in "sheet1" too, except the cell with value that need to
be found ("C1").
=IF(C1="","",IF(COUNTIF(Sheet2!C:C,C1)+COUNTIF(She et3!C:C,C1)0,"Yes","No"))

Can this be done?
Thanks!