product

Hi, I have a table of data that I turned into a pivot table. Here is an example of more or less the data I'm working with: <tbody> Date Type of movement Product A In Product A Out Unit Cost Unit Cost Client Selling Price Product A in Stock 10/11/19 A 20 3 100 10/3/19 B 10 2 Client...

Hi, I have an optimization problem, that I'm trying to solve in Excel, but it keeps getting too complex (too many columns/iterations), and I hope someone in the forum may be able to give some pointers. On a given day, at a given timeslot, I have 6 production lines, each with different...

Hi all, We're spitballing some ideas at work and want to see a map of our customer journeys. We have 19 different product types and want to see how they travel from one product type to another, or stay within the same product type each booking. I have no idea how to present this data in a...

Hello All, New to the forum and kindly request your expertise. Not certain if this question has been posted before. Specifically, in the function: MATCH(lookup_value, lookup_array, [match_type]), can we combined the "lookup_value" with OR function??? Tried using a VLOOKUP with MATCH...

Hello. In columns A (A2:A600) and B (B2:B600) I have products and in columns C (C2:C600) and D (D2:D600) their prices. When product is in column A his price is in column C (same row) and when product is in column B his price is in column D. In column E I have a list of all products (in cells...

Hi I have 2 sheets in a workbook. The first sheet ‘kit list’ has a table with a drop down boxin B12 to B210, so I can select a product from the drop down, then in C12 to C210,I can put the number of each of the products I want. There could be multiplevalues that are the same in column B...

I some data in lets say column D that has information such as: Product 1, Product 2, Product 3 Product 4 Product 2, Product 4 Product 7 etc. What i want to do is use a vba to turn this into one column somewhere else say sheet 2 column A so: the data would look like Product 1 Product 2...

Hello, I'm hoping someone might be able to help me please. I have a project that I am working on where our IT department needs a report that shows all of our companies and product numbers, but next to each product, they would like us to enter "sales exist" if it shows that the product has...

Hello there!! I have two textbox in my sheet, one in column A and the other in column B, that is because i want the user to search in two ways, by typing the ID of the product and/or the product itself. Column B works perfectly, i type the product name and it filters just the way i want it...

Hello, I am doing analysis on products and seeing what the best performing week was for them. I'm doing this for the year 2018 and 2019. On the "Best Week" sheet, which is a Pivot Table (it pulls from a data tab with the raw sales info): Product #'s are listed in column B. Years are listed in...

Hello, I’m trying to determine if there is a formula I can use that will be able to dothis. The columns in my spreadsheet represent individual dates(e.g. column B is 01/09, C is 02/09, etc). for each date there are quantities andin column A there is a product code. Each product code can...

Hi Experts, Need your help in this. My boss wants me to create values for a group of materials bifurcated on basis of pack x Channel, now the values for a pack/channel combination should sum up to 100. <tbody> Unit Brand Channel Pack Value% EAST Product 1 Insti Medium EAST Product 1...

I have created a product order form on Excel. In cell A1 I can select a product from a validation list. in cell A2 I can select from a choice of upholstery for that specific product from another validation list. in cell A3 I can select from a choice of weights for that specific product from a...

Hello to all, I have the below macros IncomingProducts and RunAgain. - IncomingProducts: This macro simulates the input coming from users of StoreA and StoreB. For example purposes I've show the data entries from both stores with arrays. - RunAgain: This macro only calls IncomingProducts to...

Hi Guys, Please help me on my project. I am creating an inventory/monitoring form that I have a multiple checkbox on my userform and when when i tick the checkbox1 it will automatically go on that particular sheet. I made a simple program like this. Sheets("Apple").Visible =...

Hi All I'm trying to build formula to lookup one column (Product) (has Duplicate value in Table Array) and if "Product" matches with lookup table ("A:B") then ---> it should look for Exact Qty or Greater Qty (column B) but the first preference is "Exact match" for reference I have uploaded...

Hi I have always used Vlookup but now I need a little bit more. I have a spreadsheet where 90% of the data and columns will remain the same but the on hand qty will always change. I created a small sample sheet where I have column A two different stores that care the same product number and on...

Hi All, I have a table of data that contains ~600k rows (1 per customer) with a list of dates that they have purchased their first product. Example of the data is per blue text in table below. Im trying to figure out an Excel Formula that will populate the values in red text. I had a formula...

Hi, Please refer to the image in the link below. I’m trying to create a data validation that lets a user choose Product and Colour of a car from the Manufacturer. Is there way to put some function in data validation list option so that it looks for Audi on the worksheet and takes the...

I've seen a few of the forums in here with similar requests - how to take a column of data and where there's matches, total the sum of those cells. The consensus seems to be to use SUMIF instead, but I do think I need to use VLOOKUP. My goal is to analyze the data, and output a tallied set of...