This macro code will take the current selected cells and check them - must be in a single column for this simple code and in the range A-Z. But the code is easily modified to allow extensions. Run brom a nenu item or toolbar buttton if you like.
Sub unique()
Dim start, finish, answer As String
Dim i, j, loopcnt, loopout As Integer
start = Left(ActiveWindow.RangeSelection.Address, 4)
finish = Right(ActiveWindow.RangeSelection.Address, 4)
start = Mid(start, 2, 1) & Right(start, 1)
finish = Mid(finish, 2, 1) & Right(finish, 1)
i = Val(Right(start, 1))
j = Val(Right(finish, 1))
answer = ""
For loopout = i To j
For loopcnt = i To j
If Range(Left(start, 1) & loopout).Value = Range(Left(start, 1) & loopcnt).Value Then If loopout <> loopcnt Then
answer = "Not Unique"
End If
End If
Next loopcnt
Next loopout
If answer = "Not Unique" Then
MsgBox "not unique"
Else
MsgBox "all unique"
End If
End Sub
Hope it helps
Stephen.