Data validation (drop down)

[mrichard]

Good afternoon all,

I have created a drop down list (using data validation) in column A say from rows 1 to 100.
Now I would only like the the drop list to appear in column A when the adjacent cell in column B is not blank.

Any thoughts?

Thanks in advance

Mark

 

[Toadstool]

Hi MRichard,

I'd need a helper column to indicate how much of the drop down to show.

MRichard.xlsx
	A	B	C	D	E	F
1	Animal	Weight (kg)				LoV
2	Sheep	1			6	Dog
3					0	Cat
4	Goat	3			6	Sheep
5					0	Goat
6		5			6	Pig
7					0	Horse
8					0
9					0
10					0
Sheet1

Cell Formulas
Range	Formula
E2:E10	E2	=IF(B2="",0,COUNTIF($F$2:$F$99,"> "))

Cells with Data Validation
Cell	Allow	Criteria
A2:A10	List	=OFFSET($F$1,1,,E2)