Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column character width on auto filter | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |