It's working, but if i don't have any number in ..let's say "C25", the code
display "no". if there is no number in a cell in "C" column, then the code to
display nothing. The cell to be empty.
Can this be done?
Thanks allot!



"Jacob Skaria" a scris:

Suppose you have the same numbers in Sheet2 Col C and Sheet 3 ColC.
And from Sheet1 you need find whether there is a duplicate; try the below

Suppose in Sheet1
C1 = 123
D1 = IF(COUNTIF(Sheet2!C:C,C1)+COUNTIF(Sheet3!C:C,C1)0 ,"Yes","No")

If this post helps click Yes
---------------
Jacob Skaria


"puiuluipui" wrote:

Hi, i need to find duplicates in all sheets and result to be, "yes" or "no".
In "C" column i have numbers, and in "D" column i need the code for
duplicates.
If any number from "C" column is find in any sheet, the code to display in
"D", "yes" or "no".

Ex
C D
123 yes
321 no

Can this be done?
Thanks!