View Single Post
  #2  
Old March 16th, 2011, 10:28 AM
tarquinious tarquinious is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2011
Posts: 34
Default

Quote:
Originally Posted by EricLeung View Post
Hi,

Whenever input data in one cell in a worksheet, how can Excel help to check if this entry (data) has never been input before after inputting the data, so that I can be sure what I have just entered have never appreared before.

Please can anyone suggest any formula / function / code which can help.

Thanks & Regards,
Eric
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.