LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Subtotal by similar brand name

Is there anyway to subtotal by a similar word in a cell? I do a lot of brand
ranking reports and each brand may have similar items with the brand name
listed in the description.

Ex:

Barilla
Barilla Plus

Racconto
Racconto Healthy
Racconto Mainstream

In the above examples, is there any way where to get a subtotal for just
Barilla and Racconto without going in an changing the brand names so they all
say Barilla or all say Racconto....
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook, Excel, Work 2007 locking up *BRAND NEW SYSTEM* mlb0328 Excel Discussion (Misc queries) 0 January 7th 08 08:55 PM
Brand Grouping Gecko Excel Discussion (Misc queries) 3 September 24th 07 01:44 PM
pasting to subtotal lines without replacing hidden -non-subtotal l harleydiva67 Excel Discussion (Misc queries) 1 October 12th 06 06:02 PM
HELP! Brand new user to excel and having problems... rdenny1900 Excel Discussion (Misc queries) 5 June 20th 05 01:37 PM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"