PDA

View Full Version : Solved: Validation data - excluded from list



jmaocubo
01-28-2011, 10:22 AM
Hi

I wonder if is possible to excluded a item (from a validation date list) after been used in another cell.

Ex:

In sheet1 i have a list in A1:A


A1 - Text1
A2 - Text2
A3 - text3
A4 - ...
....




In sheet2: cells C15:C25 if in cell C15 i select from the dropdown list "Text3" when i select in C16 the dropdown list shoud not have the tex3... and so on

The items from the list only can be selected one time (no duplicated)


Thanks in advance and sorry for my bad english

hardlife
01-28-2011, 02:37 PM
Hi, You can try this,

but there may be better way to do that.

HAPPY WINTER DAYS :hi:

Bob Phillips
01-28-2011, 04:17 PM
See http://www.contextures.com/xlDataVal03.html

jmaocubo
01-31-2011, 04:42 AM
Thanks hardlife and xld for your help...

It work's fine....:clap: