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
|