food

All hi, Kindly require to provide me a support so that a VBA code to run through col. “G” and where is missing the sub category, should place the 4 letters on left of dash in each item. However, the subcategory which consists with 4 initial letters exists in some of the items. Therefore...

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

This might sound complicated but that is because I am not really up on the lingo - sorry!! I have workseets - the first has the following data: A B C 1 Area Error type Total 2 Bradford Food 4 3 Bradford Cleaning...

Hi to all of you, kindly require to provide me a VBA code so that to fill blank cells down in col. “D” with sequence number starting the first number 1001, 1002 and so on… Therefore, that my data begin from row “12”. I present below an extract of original and expected result. Many thanks in...

Hi all, I'm having a mental blank. I have created a very simple food tracker that I can vlookup the nutrition details from a sheet that has the USDA export of all this information. My end result is a few manual columns including date, food item, grams, and then a vlookup for each nutrient...

Hello, I'm trying to make a spreadsheet for the family reunion that can be shared and answered by the recipients. I have a list of names, and a box where they can select which food they want. What I wanted is when I click a name(that has already been filled in by that user, that the box with...

Bit of a novice here so please bare with me. Trying to use an ISBLANK formula like so: =IF(ISBLANK(B26),"","Food Cost: "&B26) B26 is the cost of food. I want this formula to tie into a text line and reference both "Food Cost and cell B26 together. For the life of me and cant get this to work.

I'm trying to merge two tables together. One is a customer list and another is a product list. I want to combine the two and expand the customer list with the product list. How would I do this in power query. Customer List <tbody> Customer Product List Customer1 Food Customer 2 Consumer...

Sorry but I have not got an access to these platforms. I will attempt to express the requirements herebelow. Basically what I'm trying to attempt can be summarized in the below chart: <tbody> Reference Country Product Range Warehouse Production month Previous Quantity New Quantity Changes...

Hi Mr. Excel Forum members, I have two dogs and need to feed them variable amounts of two types of food. Dog No.1 needs 762 kcal/day Dog No.2 needs 311 kcal/day Kibble is 4 kcal/gram Canned is 1kcal/gram What I would like to do is feed variable amounts of the two types of food for each dog...

Hi all, kindly advice me for a VBA code so that to run through col. “E” and where find the codes which are in below extract, should transfer them from “Credit” side col.”J” to “Debit” col. “I”. Please see below original data and expected result. Thanking you in advance Original data <!--[if...

I run a restaurant and need some Excel help. I have a sheet and on that sheet are four columns. Column 1- tips earned Column 2- tips earned with a food runner Column 3- name of food runner/ runners that worked(if they worked) Column 4- amount of check written to servers We write checks at...

Excel 2007 <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col></colgroup><tbody> Voucher Number Date Party Name Item Name Item Group Item Description MRP Item HSN Item GST Acutal Quantity Rate Unit Discount Discount Amount Amount 001/S/18-19/PN...

I have a "SUMIFS" formula that's returning a black cell. My formula: =IF(MONTH(G1)=MONTH(NOW()),SUMIF(C150:C150,"Rent",D150:D150),"") I'm wanting to create a formula that will sum up the values in D:D BUT only if they are in the "Food" category AND only if it's in the current month (G1) Can...

Dear All, how can I use a constant array to make this formula work? basically I need a count of the food that "aida" have between jan1 to jan 4. summing them is...

Hello all, I'm trying to create a spreadsheet that will help my wife and I calculate food macros based off a single drop down box. The drop down box will have a food item and I would like to auto populate all the calories, fats, carbs and protein based off the drop down selection. Here is a...

On my main sheet, I have a row with two drop down lists. In column B, you select a food category. In column C, you select a specific food item based on the food category selected. The remaining columns to the right of that are for the macro nutrients of the selected food item (carbs, sugar...

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, I can't seem to figure out what the mistake is. I want to sum up the amounts depending on the type of expense and the month. <tbody> A B C D 1 Date Item Category Amount 2 28.02.2018 Food Food Shopping 10,00 € 3 4 Month 2 5 Food Shopping </tbody> Using this...

Hello Excelsior's! I am trying to write a formula to collect a subtotal of sales based off time periods. EG: Breakfast 6am - 11am // Lunch 12:00pm - 15:00pm // Dinner 17:00 - 00:00 Giving me FOOD & BEVERAGE total for the above periods I was going down the Line of using a SUMIF function...