filter help

[jmorgs]

I have a dropdown list. In the source part I have the formula:
=OFFSET($I$4:$I$11,0,MATCH($C$15,$I$6:$I$32,0)).
Now, I want to add into this formula a function so it only displays th
non blank cells. It sounds like I will have to use an array formula
but beyong that I am lost. Any help at all would be GREATL
appreciated!:

 

[Frank Kabel]

Hi
yiu have to use a helper column which first filters only the visible
cells. See:
http://www.contextures.com/xlDataVal03.html

fo howing the general technique