Find workbook duplicates
It's working now! Thanks allot!
"Jacob Skaria" a scris:
Try with a smaller piece and then add on..like the below formula in cell C8
with value in C9. No need to refer the Sheet name if you are in the current
sheet
=COUNTIF(C1:C7,C9)+COUNTIF(C10:C100,C9)
If this post helps click Yes
---------------
Jacob Skaria
"puiuluipui" wrote:
Hi, it's working only for "C1", but if i have the code in "C9", it's
searching only from the code down. it doesn't search above and below "C9".
I need the code to search from "C1" to "C100" except....let's say "C9", or
except the row where i have the code.
Ex:
if i have the code in "C9", the code to search in "C1-C8" ,
"C10-C100"----to ignore "C9"
if i have the code in "C15", the code to search in "C1-C14" ,
"C16-C100"----to ignore "C15"
Thanks!
"Jacob Skaria" a scris:
=IF(C1="","",IF(COUNTIF(Sheet2!C:C,C1)+COUNTIF(She et3!C:C,C1)+COUNTIF(Sheet1!C2:C10000,C1)0,"Yes"," No"))
--
If this post helps click Yes
---------------
Jacob Skaria
"puiuluipui" wrote:
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!
|