Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal function for text
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel subtotal function- put subtotals in bold text | Excel Discussion (Misc queries) | |||
Need subtotal function to return text as result | Excel Discussion (Misc queries) | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Subtotal function (again) | Excel Worksheet Functions |