is there a way i can have a drop down list to pick items from, that auto updates after every pick so that the new list i pick from has the previous selection omitted?
eg : choose from:
apples
bananas
courgettes
drink
select bananas
new list in next cell:
apples
courgettes
drink
ie there is NO SPACE between the omitted selection (i can get a list but it just leaves a blank space like this:
new list:
apples
courgettes
drink
any ideas?
eg : choose from:
apples
bananas
courgettes
drink
select bananas
new list in next cell:
apples
courgettes
drink
ie there is NO SPACE between the omitted selection (i can get a list but it just leaves a blank space like this:
new list:
apples
courgettes
drink
any ideas?