View Single Post
  #3  
Old March 26th, 2011, 07:04 AM
EricLeung EricLeung is offline
Member
 
First recorded activity by OfficeFrustration: Mar 2011
Posts: 2
Default

Quote:
Originally Posted by tarquinious View Post
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!