This is similiar to the subtotal function that ignores
hidden cells for numbers.

I'm not sure what that means but this array formula** will return the value
from the first cell of a filtered (or unfiltered) list.

Assume the full range is D2:D15.

=INDEX(D2:D15,MATCH(1,SUBTOTAL(3,OFFSET(D2:D15,,,R OW(D2:D15)-MIN(ROW(D2:D15))+1)),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Cecilia" wrote in message
...
I'm working with data that is filtered and has a subtotal function at the
top.

I have a column that shows manufacturer and would like to show the text
label of the first cell of a filtered list that appears. This is similiar
to
the subtotal function that ignores hidden cells for numbers. Is there any
way
to do this with text instead of numbers??

Thanks for your help.