product

Hi all, Sheet1 has product Bill of Materials: Sheet2 is for user to input Product & Tonnes in the INPUT section: I'm looking for VBA to calculate & return Ingredients & total Tonnes under the RESULT section. Thanks for any help in advance. Mark

Hi, I am wondering if there is anyway to calculate the Product for column "value" based on category with just using excel formula? For example, based on the table below. I want to find the product for category A = 1*2, category B = 3*2*2 and C = 3*1*2. I tried using SUMPRODUCT but instead...

Hello - it's a while since my last question, but I'm totally stuck on this one. I have a sales database which includes multiple columns and my basic quest is to have a formula that establishes if a product has had sales in the latest week so a linked table can say listed/delisted. The latest...

Hi - I have a report that spits out false info. Due date (F) populates 2 dates. In this case there are 4 x 27/06/19 that shouldn't exist. This in turn means the WIP Qty is 4 numbers short (I). How can I push (I) down everytime it finds the wrong date? That would also depend on Job # (C) being...

Hi there I have a four product code (i.e r,p,E,Y)in cell range A1:A4 and the price for that product is mentioned against each code in cell range B1:B4 (i.e 6.87, 9.18, 10.54, 22.73). I am seeking for a formula for following purpose if i enter multiple codes in a single cell (say Er,Yp,EY, EE...

Hello All, I am trying to build a template to calculate the selling price of an item given the various costs. Assuming I buy a product for $10.00, I expect to make a 10% profit Margin so technically I would need to sell it for $11.00 So far I can handle it, the issue is that the platform where...

HI All I regret that In my job I don’t get to do as much work with reports as I would like as I just keep forgetting some of the basic stuff never mind the more complex formula’s and strategies. I have a sheet called raw data that shows the company name and products that our customers have...

Good afternoon all, I'm struggling with a double donut chart. I know exactly how I want it to look in my head, but when I create it on Excel, it doesn't look the same! I have a number of products, in a number of regions. For instance: Product A has 10 in Region 1, 10 in Region 2 and 0 in...

Hi! I am trying to sum up a column that has different product names. For instance a Batavia Grand Vista and a Gazelle Grand Vista both have a sales value and I am trying to sum up all the Grand Vista's. I found a formula using SUMPRODUCT combined with ISNUMBER but I can't get it to apply to my...

Hi, Apologies.. this might be a bit vague, I'm looking for suggestions if possible. I will have a large matrix - may be 200 x 1000 To simplify the above, imagine I have a matrix of 3 x 3. Across the top (as headers) are account numbers. Down the left side are product codes. On sheet 2, I...

Hi everyone! I am new here in the forum and I looked for some solution to my problem and I did not find anything similar, so I decided to create a new post. I have a workbook with two worksheets "STOCK" and "SALES REGISTRATION". In Stock, I give all of my products that I buy to sell...

Hi everyone <tbody> Product wholeseller price/kg Apple ABC Rs 50 Orange ABC Rs 30 Apple XYZ Rs 40 </tbody> Using Product as the key i want to extract all the datas in new table like <tbody> Product ABC(Price) XYZ(Price) Apple Rs 50 40 Orange Rs 30 </tbody> I used formula to get...

Hi! I'm trying to create a chart that allows you to filter dates and product values. I tried making a table directly from the chart options but found that annoying so resorted to doing it from a pivot table date. I have what I thought was a simple range of data, just weekly dates in column A...

hello all, i'm a beginner of macro i want to create a form template to record guest inquiry, trying to write some code on textbox(es) to speed up my daily progress however i get stuck with below issue, hopefully someone can help me out, superb thanks the data will be saved into sheet2...

Hi Everyone, I'm using this formula to get item name from another excel file when I enter the item code. Am wondering if it's possible to search in 2 files and retrieve the item name. Item code will be in any of the following file. Product Master.xlsx or Archive Product Master.xlsx...

Hi everyone, I've been racking my brain and many google searches later and have been having a really hard time at this. I would really appreciate some assistance! I've got a file that has a layout like this: <tbody> Product Country 1 Product Country 2 Product Code 1 Product Code 2...

Hi I've got three groups of data over 9 rows. Each group has duplicates and I'd like to delete the duplicate rows based on data in column C, which has Cash Sales. In the table below, column A has Product IDs, column B has Product Names, column C has Cash Sales and column D has the Group...

Hi! My query is this - I have 3 columns. Barcode | Product Type | Product Name | Colour 1234567890123 | AAA | Example1 | White 1234567890124 | AAA | Example1 | Black 1234567890125 | AAA | Example1 | Red 1234567890126 | AAA | Example2 | Purple 1234567890127 | AAA | Example2 | Orange...

Hello! Once again I come to you guys in hopes of finding a solution to my problem. I have this sheet where it shows a list of our clients. We have about 13 offerings(products) and I want to color code them, so that when I look at client 1, I can see they show red and blue so that means they...

I have a sheet downloaded from a website. Column A is the product IDs. For some reason the site splits the data for some products into 2+ separate rows. I already formatted the duplicates and sorted them but I still need to combine all the data for each product into one row (sum). I need the...