product

Hy Everybody, I am sure somebody can help me: I have an Excel Table with Price Data - Product Name, Quantity (piece, weight, etc), Price in Dollar, Price in Euro. I have an additional Excel Table with 7 Sheets (one weekday each), with Product Name, Company, Sale My Question is, how can i make...

I'm working on a macro with a lot of steps for a file that needs to be recreated on a regular basis. Is it possible to have the macro modify the range in the formula each time, based on how many rows are populated in the file? (the spreadsheet doesn't always have 738 rows of data). The formula...

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