View Single Post
  #1  
Old March 10th, 2011, 03:03 AM
EricLeung EricLeung is offline
Member
 
First recorded activity by OfficeFrustration: Mar 2011
Posts: 2
Question Excel-check for unique record entry

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