Value of the actual Auto Filter

When I have a coloumn with text and one with number I can make a cell with
with the subtotal under the number coloumn - but how do I make a cell with
the actual used text-filter-value under the text-coloumn?

Example
Text Initials Hours
ELEC csn 41
ELEC mbj 33
ELEC mbj 40
CON jta 37
HVAC hte 34

I can make filter for "ELEC" and "mbj"

Text Initials Hours
ELEC mbj 33
ELEC mbj 40


aaa bbb 73

And I can get "73" as subtotal (using "=SUBTOTAL(9;C2:C6)") but how do I get
"ELEC" in the aaa-cell and "mbj" in the bbb-cell??


--
Best Regards
Hans Engen
Denmark

Here's one way:

http://tinyurl.com/5v5yp

HTH
Jason
Atlanta, GA

>-----Original Message-----
>When I have a coloumn with text and one with number I
can make a cell with
>with the subtotal under the number coloumn - but how do
I make a cell with
>the actual used text-filter-value under the text-coloumn?
>
>Example
>Text Initials Hours
>ELEC csn 41
>ELEC mbj 33
>ELEC mbj 40
>CON jta 37
>HVAC hte 34
>
>I can make filter for "ELEC" and "mbj"
>
>Text Initials Hours
>ELEC mbj 33
>ELEC mbj 40
>
>
>aaa bbb 73
>
>And I can get "73" as subtotal (using "=SUBTOTAL
(9;C2:C6)") but how do I get
>"ELEC" in the aaa-cell and "mbj" in the bbb-cell??
>
>
>--
>Best Regards
>Hans Engen
>Denmark
>.
>