chicken

  1. R

    Counting Formula

    Hello Wonderful Helpers, I'm wondering if there is a formula that can count until a leading cell changes content. When the cell changes it starts back at 1?? I need to do this on a large scale. For example: <colgroup><col><col></colgroup><tbody> Fox 1 Fox 2 Dog 1 Cat 1 Cat 2 Cat 3...
  2. J

    Remove Blanks from Adjacent cells

    Hi Guys, I'm trying to remove the blanks from an adjacent column as per the table below. Any ideas from you wonderful people? <tbody> Data 1 Data 2 Result 1 Cat Cat Dog Chicken 1 Chicken Sheep Cat Apple 1 Sheep 1 Apple Banana </tbody> Thanks!!!
  3. D

    Data categorizing macro

    Hello all, I am very new to VBA and apologize in advance for the 'simple' question. I am working with thousands of rows of data in a pivot table data sheet where there are 8 categories as shown: <tbody> Month Product ID Product name Sales Rep Product Category Product Brand Quantity Value...
  4. M

    Subtotal using formula

    <colgroup><col><col><col><col><col span="2"></colgroup><tbody> Date Items - Nov'18 Qnty Rate Amt. Subtotal 1.11.18 Executive Non Veg Lunch 2 40 80 80 2.11.18 Chicken Biryani 2 95 190 Chicken Bharta 2 45 90 280 3.11.18 Egg Fried Rice 1 36 36 Chilly Chicken Boneless 1 45 45...
  5. D

    calculating macronutrients

    I just started a food diary and am wanting Excel to calculate my calories and macro nutrients automatically. Not sure how to do this, but would like for it to multiply the number of servings I had by the calories, Fats, Carb, and Proteins each day, and add them up for the day's total. Add all...
  6. B

    Using text as data

    Okay so I need some help here. <tbody> Apple 10 Orange 5 Drink 7 Banana 13 Chicken 3 Oil 4 </tbody> I want to be able to either: 1. Convert certain words into numbers. E.g "apple", "orange" and "banana" into a 1. "Chicken" into 2, "Oil" into 3, and "Drink" into 4. So it will...

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