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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top