Find workbook duplicates
 

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!

Find workbook duplicates
 

=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!

Find workbook duplicates
 

You need to adjust the row number to your requirement...
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

=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!

Find workbook duplicates
 

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!

Find workbook duplicates
 

Hi, i modified youre code. Can you tell me please if it's good? I don't want
to receive bad data.
=IF(C9="","",IF(COUNTIF(Sheet2!C:C,C9)+COUNTIF(She et3!C:C,C9)+COUNTIF(Sheet1!$C$1:C8,C9)+COUNTIF(She et1!C10:$C$100,C9)0,"Yes","No"))
Thanks allot!

"Jacob Skaria" a scris:

You need to adjust the row number to your requirement...
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

=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!

Find workbook duplicates
 

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!

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!