Duplicates In A List

[Guest]

My spreadsheet uses a list of times in a column, but I need a way to ensure during data entry that I do not enter the same time twice (or thrice) - kinda

During data entry I wish to be able to enter a time in the usual hh:mm format (no problem there), but I want Excel to flag me if the time entered has been used before in the list and then I can add a second (i.e. hh:mm:ss) to the time to make it unique; but obviously I want to avoid the potentially time consuming prospect of checking the list for duplicate times prior to data entry

Many thanks in advance to those who can help

 

[Frank Kabel]

Hi
see
http://www.cpearson.com/excel/NoDupEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany

My spreadsheet uses a list of times in a column, but I need a way to

ensure during data entry that I do not enter the same time twice (or
thrice) - kinda!

During data entry I wish to be able to enter a time in the usual

hh:mm format (no problem there), but I want Excel to flag me if the
time entered has been used before in the list and then I can add a
second (i.e. hh:mm:ss) to the time to make it unique; but obviously I
want to avoid the potentially time consuming prospect of checking the
list for duplicate times prior to data entry.