|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 14th, 2009, 12:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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! 
|
|
#2
May 14th, 2009, 12:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
|
#3
May 14th, 2009, 12:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
|
#4
May 14th, 2009, 01:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
|
#5
May 14th, 2009, 01:16 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
|
#6
May 14th, 2009, 01:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
|
#7
May 14th, 2009, 02:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
