| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get a copy of the first row Text value displayed in a filte
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy displayed value only? | Excel Worksheet Functions | |||
| Allow users of protected sheet to use macro involving custom filte | Excel Discussion (Misc queries) | |||
| Text not fully displayed when text direction changed | Excel Discussion (Misc queries) | |||
| HOW DO I TOTAL A FILTERED LIST TO EXCLUDE THOSE EXCLUDED BY FILTE. | Excel Worksheet Functions | |||
| Copy just displayed columuns | Excel Discussion (Misc queries) | |||
Linear Mode
