Find workbook duplicates

  • Thread starter Thread starter puiuluipui
  • Start date Start date
P

puiuluipui

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(Sheet3!C:C,C1)>0,"Yes","No"))

Can this be done?
Thanks!
 
=IF(C1="","",IF(COUNTIF(Sheet2!C:C,C1)+COUNTIF(Sheet3!C:C,C1)+COUNTIF(Sheet1!C2:C10000,C1)>0,"Yes","No"))
 
=IF(C1="","",IF(COUNTIF(Sheet2!C:C,C1)+COUNTIF(Sheet3!C:C,C1)+COUNTIF(Sheet1!C2:C10000,C1)>0,"Yes","No"))
 
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:
 
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:
 
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(Sheet3!C:C,C9)+COUNTIF(Sheet1!$C$1:C8,C9)+COUNTIF(Sheet1!C10:$C$100,C9)>0,"Yes","No"))
Thanks allot!

"Jacob Skaria" a scris:
 
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(Sheet3!C:C,C9)+COUNTIF(Sheet1!$C$1:C8,C9)+COUNTIF(Sheet1!C10:$C$100,C9)>0,"Yes","No"))
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Conditional Concatenate? 2
if, then display message 1
Calculate Range 3
Drag down the cell links of multiple sheets 5
macro help - copying a list of names 5
Comparing Sheets while ignoring Case. 2
Sheet to sheet code Type Mismatch 6

Back
Top