Identifying duplicates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DonH - 06 Nov 2006 17:36 GMT

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","")

Reply to this Message

bobocat - 07 Nov 2006 03:45 GMT

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" <d.hart440@ntlworld.com> ¼¶¼g©ó¶l¥ó·s»D:VoK3h.14182$163.11385@newsfe6-gui.ntli.net...

> Hi,
>
[quoted text clipped - 12 lines]
>
> =IF(SUM(IF(FREQUENCY(U14:U77,U14:U77)>1,1))>=1,"Duplicate","")

Reply to this Message

DonH - 07 Nov 2006 12:33 GMT

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
[quoted text clipped - 24 lines]
>>
>> =IF(SUM(IF(FREQUENCY(U14:U77,U14:U77)>1,1))>=1,"Duplicate","")

Reply to this Message

Rate this thread: