products

I have a spreadsheet which I am using vlookups. when I enter an item it will auto populate the product code into another cell. The content is also from a validated list, though has over 2000 products. is there a way of typing the start of a name to locate products that start with those letters?

Hi! Background: I work with customer service and want to register how long they have to wait before they get their products. I receive a receipt from each customer and then we are multiple people at once picking their orders. How I have done thus far: I use the "Forms" function to add...

Hello to everyone. I have this situation (products / quantity / year) In column "I" i want to put quantity for these products which corresponding with year 2018 (cell "M2") Thansk's <tbody> A B B D E F G H I J K L M N O Products Quantity [kg] Year 00000 00000 000 0000 Products Qnty [kg]...

Hello Everything, I'm asking you for some solution with my problem. I turned the internet over, but I still can not find a solution to my problem. I have a table in which column A2: to the end I have products in column B2: by the end I have sold pieces of these products. My problem is that for...

Hey community, I need formula to show TOP 10 smallest values with their names ( Cell A1:A119 contains names of products and B1:B119 quantity of products ) Note: some products got same quantity

Hi, I'm asking for your help, I'll try to explain as detailed as possible what I'm in need of(and couldn't figure out a way to do it yet). So, I have a table that contains a number of products, for each product the yield is introduced each week, I would like to achieve to get the top 4 worst...

Hi I have a large Excel file with price and revenue data for different products for different customers. Customer ID Product Revenue Jan Revenue Feb . ... ..... Joe´s pizza dough 10000 Joe´s pizza tomatos 42525 Joe´s pizza cheese 52525 . . . Sushi place...

Hi, I have a small file that I can attach, if needed. It is about 400kb in size. I have tried multiple different angles on this work, but just can't seem to get this working correctly. The workbook contains (3) worksheets. One sheet is titled "PRODUCTS" and the others are "INVENTORY SKUS"...

Hi all, I would like to use an an ActiveX ComboBox to drive the formatting of the Excel workbook. Particulars of relevance: - ComboBox name: ComboBox1 - ComboBox options: Total, Products, Services What I have thus far: However selecting the drop-down options in the ComboBox does absolutely...

Hi, I am using If clauses to create 4 different scenarios for some modelling. My output is the total number of products for 2018, 2019, 2020, etc. Right now I can change a drop-down and I see the number of products changing in each year. I would like to somehow be able to create an output sheet...

<tbody> Sum 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan ? HQ5 HQ1 HQ1 LQ1 LQ3 LQ2 </tbody> HQ=High quality LQ=Low quality Hi, I have a gantt chart that I log how many high-quality products and low-quality products that are produced per day. How do I keep the get a sum with a criteria for each...

Hi There, I hope someone will be able to give me some tips! I have 52 worksheets (one for each week of the year) each with about 6k lines on. Each sheet has a list of products and their sales for that week. I am trying to create one master sheet with a total sale for each product. I...

Hello, I'm new at this and trying my hardest to create a pivot table that reads multiple worksheets in my file - but I keep hitting brick walls! I'm wondering if anyone is able to help me, pretty please? My file is for someone who has customers ordering beauty products from her. Each...

Hi, I have a pivot table that shows Product Category & then Product Name in Rows. I then have the number of products that we have sold as the values with the name of who sold them in the column. My problem is that I want to be able to view just one employee and display the products they have...

Hi everyone, Can anyone help with this one please? I've got a list of items orders, the columns include the revenue from each item, the order number, and its unique product reference number. In this first piece of work, i have a list of 634 products ordered, that list is made up of 533 unique...

Hi guys, First of all, my apologies because I am attaching a picture. The excel add-in to upload files didn't seem to work with me I have this table of products. Some products have one active ingredient and some have more than one. I need help with a formula (in another table) that finds...

Hello, I am not sure how I should create my table so that I can show a vendor who supplies multiple products along with their contact information. I want to create a table with my vendors in one column with their information in a single row. The problem is I don't know if I have to list the...

I have three sheets, A, B , C.... Where in A I have values for all my products, in B I have the sold products, , in C I have the rest of the value which is the unsold products, all the values are scattered randomly on every sheet. Now I if I wanted to add a column in the sheet: A, that will...

Help lol i have data in a sheet and it is variable number of rows always changes. within each row of data is various columns of data. i would like it to consolidate the data to a new sheet so that any identical product codes are consolidated so I just have number of products for each code...

Hi Everyone, Hope you can help with this, I am trying to make a list of products, the formula I need is this I have my products in batch numbers from 1 on I need to make a list of this batch numbers but miss out the numbers that have zero products at the moment So for example In Sheets "...