Times for Appointment in drop down list - prevent duplication?

[cyuu]

Hello Everyone!

I'm not an expert in spreadsheets, so every help is appreciated! :)

There's a drop down list of appointment times and the user is to select a time. Their record gets copied to a "database" along with all the other records.

Is there a way to update the drop down list so that it only contains the time which aren't used? <used times are displayed in the database~
or is this not possible?

Sorry for the trouble,

Thank you so much for reading! and the help, if any~

[ratcat]

G'day and welcome to the forum,

This is one way......Hide Previously Used Items in Dropdown

Tho I'm sure someone else has other idea(s) they like to share to help you out.

[Melvinrobb]

You could enter the following formula in M4 and drag down, and make M4:M21 as your source list:

Please Login or Register  to view this content.

If you want the list to not have blanks, you could enter the following formula in O4 and drag down, and make O4:O21 as your source list:

Please Login or Register  to view this content.

[cyuu]

haven't tried it yet^-^ but thank you so much for the kind response!

[cyuu]

Haven't tried it just yet C: but thank you very much for the response!