product

Need experts help on this after racking brain over and over. I have a data sheet, 'DATA', that contains Product and Pricing detail by row. Each row will have a column for Product Name (ie. Product A, Product B, Product C....etc), and a column for Location, (ie.Location 1, Location 2, Location...

Hi, I have created the following formula to calculate the ratio of monthly growth rate of sales of Product A (in row 3) when the sales of Product B (in row 4) are growing, to the positive growth in sales of Product B...

Hi, I have monthly sales data for two products arranged as follows: Column A: Consecutive month-end dates (e.g. 31/12/2018, 31/01/2019, 28/02/2019 etc) Column B: Monthly sales values for Product A Column C: Monthly sales values for Product B I would like to create a formula that will...

Imagine a file with about 20,000 rows and each row has product data. The first column has the product name sorted so all the rows for a particular product are in contiguous rows. I need something to split up all the rows for each product into their own tabs - in this file or a new one. It...

Hi, In sheet 1 I have product ID's that might be stacked with multiple ID's in a string. Product ID's might have different amount of numbers and combinations with letters, e.g.: Cell/product ID A1: 12345, A1122334, 7654321 A2: A9988776, 54321 A3: 7776655 In sheet 2 I have all invoices per...

<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 7/1/2019 Product 1 0 0 0 0 0 0 0 Product 2 0 0 0 0 1 0 1 Product 3 0 1 1 2 0 0 0...

Complicated but... here's the final product I need: Bold = data I have non-bold = data how I need it to show <tbody> Customer A Customer B 20 120 Product 1 10 10 Product 2 10 10 Product 3 80 80 Product 4 10 10 Product 5 10 10 Product 6 10 10 Product 7 10 10...

I have two columns Column A and Column B Column A has all existing product codes Column B has all existing and new product categories Old Product codes consists of two parts two letters and a 6-digit number the letters always remain the same ER the numbers were picked at random. So existing...

I would like to know if it is possible to use text from a cell to define a worksheet name within a vlookup? I have a power query with item product codes, each product code has its own worksheet containing details of the item Currently I am manually changing the name of the sheet within the...

Hi, Please note the following request will be to action this only in Excel - I'm on a works pc and don't have other software available to do this. I have 3 lists of product codes. The codes are in a random order and can be duplicated across the the 3 columns. Each product code has an...

Hi. I have difficulties with resolving the following issue: I have the prices for the Product #1 that are monthly revised (Table _ Primary data). Some months are blank, that means there were no price review in this period (e.g. as of 3/1/2019), thus, the price of previous month remains actual...

Hi all I've been trying to come up with a solution for a little while but am just not seeing what I need to do to get there... I was hoping someone on these excellent forums may be able to assist? Background: I have 5 tables with 12 columns each (i.e. months) in my back pages. The 5 tables...

Hello, I have a very very big problem with my last Pivot table. I have to calculate difference between Parent total and intermediate value, but not in percentage terms. I need to find difference in numeral. In my table is a leading product code. I have many product codes each of which...

Hi, Detail of data: Column A has a list of product codes (of which there can be duplicates upto 5000 duplicates but in some cases, there may only be 1) Column B has a list of associated product codes (there may also be duplicates as more than one of the products in Column A can be associated...

Hi I am creating an excel where in 1 sheet I will take lets say the order: i.e: Date, Customer Name, Product Code, Qty and on the sheet 2 I will have on the A column all the products and on A2, A3,A4, A5 .. all the customers. What I want to do is to be possible the Sheet 2 to read from Sheet 1...

<tbody> A B C D E F G H I J K L M Date Route Product 1 Product 2 Product 3 MAY May 1 3 23 32 29 Route P1 P2 P3 May 2 5 35 53 71 3 May 3 6 14 27 12 4 May 4 5 18 81 65 5 April 30 3 54 19 21 6...

Hi, I am trying to do a function in excel but i am having difficulty coming up with the formula for it. So basically what i want to do is: Column A(Cells in this column are drop downs) Column B Column C Column D Column E Product A...

I have Table A like this Country, Product, Sales ========== US, A, 100 UK, A, 200 US, B, 150 UK,B, 350 In Table A it is like this Country, Product, Rate =============== US, A, 0.9 UK, *, 0.7 I want to join these 2 tables if both Country and Product are same as those in Table B, so that Rate...

In sheet1, I have a list of barcodes. In sheet 2 I have 2 columns of barcodes and and a column of product codes. In sheet one, against the barcode, I'm trying to get the product code but as mentioned I've 2 columns of barcodes. how do I incorporate the 2 columns of data? Is it a lookup or...