juice

  1. B

    Calculating the difference in quantity from a matrix

    Hi Everyone, Have come here seeking for some advice and will try to explain as best I can. The scenario is a food company that deliver's a set amount of products dependent on the amount of customers that are booked on a specific day. So I have a main spreadsheet with a list of food items...
  2. K

    Pivot the Same Data Multiple Times

    Hello - I am trying to pivot the same data multiple times to understand the all sub-level components of my finished parts. I have a list of parent items and the items that make them up which looks like this: Parent Item (A) Component Item (B) I can pivot the parent to component to get all...
  3. A

    VLOOKUP Question

    Hello! I've been asking a lot of questions lately, but please bear with me. I am trying to learn as fast as I can. I have two columns, V & W. What I want to see if I can do is vlookup V5 & vlookup W5 in the same table and combine them together. Example, in Sheet1 Column V says Apple and Column...
  4. N

    Replace Carriage Returns & Remove Last Comma

    Using VBA is there a way to replace carriage returns with a comma space? Also, if the value ends with comma space or comma i''d like to delete those value. This will be done on sheet called Cranberries in coulmn E only. EXAMPLE <tbody> CURRENT WANTED RESULTS APPLE JUICE GRAPE JUICE...
  5. G

    Index Match Small with duplicate values

    Hello! I am trying to get the product names by store that are the "bottom 3" in the following table: <tbody> Product Store Budget %Achieved Soda A 10.00 46% Juice A 20.00 0% Coffee A 25.00 0% Water A 30.00 0% Tea A 40.00 0% Soda B 5.00 10% Juice B 15.00 90% Coffee B 60.00...
  6. E

    Sum multiple criteria along X and Y axis

    I need help in finding totals of multiple criteria along both the X and Y axis. <tbody> Atlanta Cleveland Reno Hamburg Decatur Dekalb Hornbrook Hilt Yreka Redding Red Bluff Carson City Tillimook Coke 10 4 13 6 8 4 3 2 6 3 2 4 7 Pepsi 1 12 5 43 56 1 2 5...

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
Back
Top