Subtotal function for text

  • Thread starter Thread starter Cecilia
  • Start date Start date
C

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.
 
This is similiar to the subtotal function that ignores
hidden cells for numbers.
Click to expand...

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,,,ROW(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)
 
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
 
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
 
Back
Top