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,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Denise" wrote:

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