Function select unique

[dennisli]

Good afternoon,
In range A1:A100, there are 100 names. But some names maybe come out more than one time, like there are three John.
In column 2, I want to show the unique names, like only one John shown even there are three John in column 1.
Can I use some functions to achieve it?
Thanks lot.
Dennis

 

[ctrlaltdel]

Check out this thread.
http://www.mrexcel.com/board2/viewtopic.php?t=89702&highlight=

 

[dennisli]

thanks.

 

[Cbrine]

Here's a UDF that I created to ID unique or duplicate values. Just store it in a module on the current workbook and call it on the worksheet

=FindDuplicate(A1:A500,A1)

Public Function FindDuplicate(SearchRange As Range, Value As Range) As String
Dim R As Range
For Each R In SearchRange
If R.Address <> Value.Address Then
If R.Value = Value.Value Then
FindDuplicate = "Duplicate Value"
Exit Function
End If
End If
Next

FindDuplicate = "Unique Value"
End Function