Validation List and zero values

[stakar]

Hi!
I have a problem that i cant solve
I create a validation List but the sourse range that i use for the list includes zeros.
Is it possible to get all the numbers from the range except the zeros?

Thanks in advance
Stathis

 

[Aladin Akyurek]

Hi!
I have a problem that i cant solve
I create a validation List but the sourse range that i use for the list includes zeros.
Is it possible to get all the numbers from the range except the zeros?

Thanks in advance
Stathis

One way is to create another range by means of formulas that eliminate blanks, 0's, duplicates, etc., which then can be used as the source in data validated cells. This approach would be appropriate in particular when the original list crimps or expands.