Value of the actual Auto Filter

[Hans Engen]

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??

 

[Jason Morin]

Here's one way:

http://tinyurl.com/5v5yp

HTH
Jason
Atlanta, GA