help!!!

[useratloser]

i'm new to excel and i have a crucial project going on at work.

within a given column i need to verify that a certain value is not
duplicated. i am trying to attempt to output yes/no in another column
if there is a dupilcate. i have thousands of items and can not do this
manually. it must be done today. please help.....thx

 

[Bob Phillips]

In B1

=IF(COUNT(A1:$A$1,A1)>1,"I","")

and copy down over all rows.

It highlights 2nd, 3rd, etc occurrence of a value.

 

[Jean-Paul Viel]

Hi,



Try it. If your data don't begin in A1, just edit the macro.



Public Sub Dupli()

Dim intIN As Integer

Dim intOut As Integer

Do Until intIN >= Range("a1").CurrentRegion.Rows.Count

intOut = intIN + 1

Do Until intOut >= Range("a1").CurrentRegion.Rows.Count

If Range("a1").Offset(intIN, 0).Value =
Range("a1").Offset(intOut, 0).Value Then

Range("a1").Offset(intOut, 1).Value = "Yes with " &
Range("a1").Offset(intIN, 0).Address

End If

intOut = intOut + 1

Loop

intIN = intIN + 1

Loop

End Sub

 

[useratloser]

thx for your help bob. do you minid if i email you w/ a copy of my
spreadsheet so you can see what i'm doing wrong?

 

[Bob Phillips]

Not at all. Mail away.