ice

  1. A

    partial match string in excel with unordered lookup value

    Hi Guys, Im wondering if I could lookup partial match based on below case; let say I have value in column A row #1 in sheet A: <tbody> "Rexona Men Deodorant Roll On Ice Cool 50ml" and in the other sheet (Sheet B), I have value: <tbody> "Rexona Ice Cool Roll On 50ml" What I need is to...
  2. A

    Power BI: Include Total Average on the chart.

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

    Finding the Sum of the Values Within Unique Cells Based on 2 Criteria in a Range

    I want to find the sum of the range within the sector within the zone but only summing unique values. For example, I want to find the sum of the Codes within Sector Ice Cream, Zone 1. However I don't want to count duplicates within that range. $63 Dollars should be the total of Sector Ice Cream...
  4. I

    How Many Coctail With Fruit From İnventory -most effective ways(combination)

    hi everyone i need some help from coctail macros/vba codes. i have some fruits(14) every week this fruits counts changes. example this week we buying 23 berry next week maybe 10 another week maybe buying 30 berry. we have unstable gradient "fruit ice" (its mean ice + fruit ) just...
  5. S

    Write several words in a cell conditionned to statements in several other cells

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top