Identifying duplicates

[DonH]

Hi,

I am using the formula below to flag duplicate entries in a column of unique
numbers. This works fine but I am also using Paste Links to carry the
information forward to the following month and where there is no information
to link to I am of course getting 0 which the the formula is picking up as
duplicates (I have three blank rows to allow for additions to the unique
number list).

I would really appreciate any help with this.

Thanks in anticipation.

DonH




=IF(SUM(IF(FREQUENCY(U14:U77,U14:U77)>1,1))>=1,"Duplicate","")

 

[bobocat]

Let me try
I use this formula to flag duplicate
=if(countif($u$14:$u$77,u14)>1,"duplicate","") then copy the formula
downward

If data comes from other source and paste link to it, to aviod countng the
blank cell from the sources
=if(countif($u$14:$u$77,u14)>1,if(isblank([source link!cell
address]),"","duplicate"),"")

 

[DonH]

Many thanks for the suggestion but I was looking to have a single cell at
the top of the column to serve as flag.

Many thanks

DonH

Let me try
I use this formula to flag duplicate
=if(countif($u$14:$u$77,u14)>1,"duplicate","") then copy the formula
downward

If data comes from other source and paste link to it, to aviod countng the
blank cell from the sources
=if(countif($u$14:$u$77,u14)>1,if(isblank([source link!cell
address]),"","duplicate"),"")

Hi,

I am using the formula below to flag duplicate entries in a column of
unique numbers. This works fine but I am also using Paste Links to carry
the information forward to the following month and where there is no
information to link to I am of course getting 0 which the the formula is
picking up as duplicates (I have three blank rows to allow for additions
to the unique number list).

I would really appreciate any help with this.

Thanks in anticipation.

DonH




=IF(SUM(IF(FREQUENCY(U14:U77,U14:U77)>1,1))>=1,"Duplicate","")