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.