cream

Mr Excel, I am trying to pull a dependent part number based on its assembly level in a bill of material. Here is the bill: <colgroup><col width="65" style="width: 65pt;"><col width="104" style="width: 104pt;"><col width="82" style="width: 82pt;"><col width="114" style="width...

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...

Hi all, I want to create a very simple dispensing program. I have an excel listing of medications - see below. I want to be able to do a 'wildcard' search for a particular medication and then be able to enter the quantity dispensed. The quantity dispensed should be added to the cumulative total...

Hello guys! I am currently doing a qualitative analysis of short comments. I have created a spreadsheet with comments as rows and categories (or 'codes') as columns; so that for the comment "I like ice cream and tea", I will tick the category "food" and "beveridge" ("ice cream" being included in...

Hi all i have this: A1=Apple with sugar at A2=Apple with salt at bottom A3=Chese cream with banana and in: h1=1 j1=Apple h2=2 j2=Chese cream h3=3 j3=Orange h4=4 j4=Table i want in B1 know if A1 start with any value of j if yes put the h column in this case: A1=Apple with sugar at...

I need to count not only by item no but also color. In the following example, the desired result is in blue. Row 5 and 6 have the same item number and color. Thus, the sum is 22 (16+6). The closest thing I can get is with the following formula, whose result is in the last column. It seems I need...

Hi All I have a large list of data that I would like to add a search function to, what I am trying to do is type some or all information in the "Search for" boxes and have a list of results returned in the "Search results". I would prefer a formula rather than VBA/Macros. Thanks for your...