March 26th, 2011, 06:04 AM
|
Member
|
|
First recorded activity by OfficeFrustration: Mar 2011
Posts: 2
|
|
Quote:
Originally Posted by tarquinious
Assuming your list is in column A, use the following formula in column B from the second item in the list down.
=IF(ISERROR(VLOOKUP($A2,$A$1:$A1,1,FALSE)),"Unique ","Already Used")
If you copy that down the list the formula will adjust itself as it goes.
|
Thanks a lot, it works well!
|