Pull Row Data from Filtered Table

Seems like you can do this with a formula, but I'm not even sure what terms I need to be searching. I'm using a table with a category column. Users will then filter, so that only one category is chosen, meaning the entire column will say the same category. I want to pull this data (first non-hidden cell in category column) to a cell above the table to act as a title or label. Let me know if I need to explain further.

Let's assume column A is your "category" column, and the categories are listed in range A11:A100.
Create a helper column (which may be hidden) in, say, column X -- put the following formula in cell X11 and drag-copy it down to X100:

=SUBTOTAL(103,A11)+0

Then, put the following formula in your "label" cell:

=INDEX(A11:A100,MATCH(1,X11:X100,0))

Now, when you apply filter, the "label" will show data from the first non-hidden cell in the "category" column.

Root, your formula worked perfectly! Thanks!!