chocolate

Hi all, This is taken from a previously asked question but that allowed VBa. In this case I am trying to do it via formula and not use multiple columns to get the result. IE only the cell in "C" has a formula. This should keep all guru's busy for awhile :laugh: I sure as heck have not got far...

Hi! I'm trying to figure out a smart way of comparing text strings in two columns and returning the values that are unique for column B in column C. The order of the values is random and superfluous commas and spaces need to be removed (no commas occur within the individual values). All help is...

Hi. I have to chart the results of a poll. The poll groups questions by categories. For instance: the Dessert category includes Ice Cream, and the Flavors question includes Vanilla, Chocolate and so on. I need to include the total average for the category in the chart. This is an example (the...

How do I merge 3 to 7 cells with text strings such as: A1= Baking Powder, B1= Chowder C1 = Chocolate powder D1 = Soft Gel E1= Chocolate The desired outcome is:" Baking powder, Chowder, Chocolate powder, Soft Gel, Chocolate" I got an error with Transpose as soon as it encountered a 2-word...

I need help with combining Index and Match. Can someone tell me why this isn't working? Below is an example of my worksheet. What I'm trying to do is create a dynamic Index/Worksheet combo that will help me identify the additional cost for the type of filling and size of cake. So, for example...

Hello, I am trying to create an excel table that can filter a column based on what is in each cell (using autofilter for now). I was wondering if there is a way to have multiple values in a single cell within that column? Example: <tbody> Name Flavor (filter) Bob Cherry, Chocolate...

Please is it possible to create sublists to groups of items list through a combo box drop down list such that each time you select a group a sublist displays all items belonging to the group?. For example if Chocolate represents a family of chocolates the when select chocolate from drop list a...

Please, is it possible to create sublist to groups listed from dropDownList in a combo box such that each group of items selected can have a sub DropDownList? For example if Chocolate represents a group then when selected will display all brands of chocolate in that group. Please help me...

In a new column I want the result to be "Channel" except for the following criteria: If column A(District) = Intercompany and if column C(Product group) <> Chocolate and column B(Country) = US with column C(Product group) = Fruit, veg or Minerals Does this make sense?