Solved: Validation data - excluded from list

[jmaocubo]

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]

Hi, You can try this,

but there may be better way to do that.

HAPPY WINTER DAYS

[Bob Phillips]

See http://www.contextures.com/xlDataVal03.html

[jmaocubo]

Thanks hardlife and xld for your help...

It work's fine....