MrExcel.com - Your One Stop for Excel Tips & Solutions

Duplicate Entry

Posted by Richard Jones on November 23, 2001 3:16 AM

Is there a way as i input an alphanumeric string into a cell for me to be notified if that has already been entered on the sheet, by using data validation?

thanks

richard

Posted by Aladin Akyurek on November 23, 2001 5:35 AM

See, e.g., http://www.mrexcel.com/tip008.shtml