Subtotal function for text

[Cecilia]

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.

 

[T. Valko]

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 D215.

=INDEX(D215,MATCH(1,SUBTOTAL(3,OFFSET(D215,,,ROW(D215)-MIN(ROW(D215))+1)),0))

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

 

[James Hannaford]

That's fab for outputting the first row from a filtered list, but how do I output the second, third, fourth ect....

I can't figure out how this formula works or even if it's possible.

MTIA.

Jaes

 

[James Hannaford]

That's fab for outputting the first row from a filtered list, but how do I output the second, third, fourth ect....

I can't figure out how this formula works or even if it's possible.

MTIA.

James