Need Text columns to pull into subtotal lines

[Denise]

I have an extensive spreadsheet that has both text and number columns. I
need some of the text columns to "sub-total" on the line I do sub-totals on.
EX:

GPS GPS Jim Offshore 100.00
GPS GPS Jim Offshore 300.00
Jim Total 400.00

When I do the subtotal by name I would also like the "GPS", "GPS" and
"Offshore" wording to pull into the subtotal line. How can I do this?

 

[Shane Devenshire]

Hi,

Are you using the Data, Subtotal command? If so there is no way to do this
unless your resort to VBA or manually entering a formula.

 

[Shane Devenshire]

Hi,

Continuing with the previous, suppose your data looks like this and extends
from A1 to E100:

Other Thing Name Location Value
GPS GPS Jim Offshore 100
GPS GPS Jim Offshore 300
Total GPS-Offshore 400

Where you want to display the GPS and Offshore in cell C4.
1. Select column C down as far as the data extends
2. Press F5, Special, Blanks, OK
3. Type the following formula and then press Ctrl+Enter
=IF(E4<>"",A3&"-"&D3,"")

 

[Ashish Mathur]

Hi,

You can try something like this. Highlight the range and then hit F5 >
Special >Blanks. This will highlight all blank cells. Now just do = up +
arrow key and Control Enter.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Denise]

I was doing fine til I got to the part where you state now just do - am I
typing in the = sign, then the word "up", then the plus sign, which arrow key
and then cntl enter?

 

[Denise]

I just got it to work after playing with it. This is going to be a time
saver- thank you so much.

 

[Denise]

I appreciate your response. I followed the response by Ashish which is
similiar to yours and it worked.

 

[Ashish Mathur]

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com