How to get a copy of the first row Text value displayed in a filte

I

icsonu

Hello All,
I have a Sheet in which i have 12 columns containing text Values, and 4
columns having numeric values. I have got the average by using SUBTOTAL
option of the displayed rows. Now I would like to know how can I get a copy
of the row text after applying filter (Since when i apply filter the first
row below the filter changes as per my filter option) next to my SUBTOTAL
Average . I would like to know if there is any option like " = Text value
displayed in the first row"

Regards,
icsonu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Getting Text data using the Data - Subtotal feature 1
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
Need Help with a VBA subroutine 0
PivotTable - Filter Row 0
Average value only for the filtered area.. 4
How to modify and updte specific styles for specific paragraphs across the document 0
Problem with MS Word paragraph and character styles: format getting messed up 2

Top