products

I'm a bit of a novice Excel formula user/creator. I have an extensive formula to create and I'm not sure if it's even possible. I have 24 different products (see below). <tbody> Sprinkles Sprinkles Vanilla Vanilla Chocolate Chocolate Plain x x x x Powdered x x x x Old_Fashioned x...

Hi guys/gals, I need your help. I have 2 excel worksheets. One is inventory the second is products. This is what the Inventory sheet looks like, minus 6 other columns: <tbody> Product ID Description 100006 3 PC BAR SETBLK WEATHEED; BARK 100018 3PCS BISTRO SET,CARAMEL ;BRWN/CHARCOAL...

I want to Add Accesories to Main Products There are Two Worksheets( MainProducts ). Name List of Main Products. and Worksheets(Acessories). List ofAcessories of Main Products. Basically There is comman column("B") in both Worksheets(MainProducts) . Names of Main Products. and...

Hello all, I am in need of some creative ideas for the following task: I need to compare hundreds of products to each other to find products that are similar/dis-similar based on the ingredients in their recipes. See below example products to illustrate my idea. In this product set I need some...

Hi, I have a workbook with several data sheets which I want to combine. However, each sheet contains unique data but also some same data. For example, sheet one has products with A and Value, sheet 2 has products with B and Value. So the only different thing is between the products. Because of...

Greetings! I'm trying to create a rolling inventory for a series of products in a table that can be expanded indefinitely. Along the Y-axis are two groupings, products created and products sold. These are the only two ways products come and go. Within each grouping are a few empty cells, each...

Hi, I have a worksheet that contains 119K lines and 150 columns. All the column headings are unique and the columns contain specific information and data about that particular product. Some products contain data from multiple columns. Eg below - Oil Seals - contains dimensional date in 4...

Hi All, You helped me in the past - hope you can guide me this time as well :) Sorry I didnt know how to correctly title this post... My issue: In sheet 'one' I have a simple list of products with the price, etc. Column 'C' is for quantity ('ILOŚĆ') If I type specific quantity in the 'C'...

I need to change my ERP system to a serialized inventory system, i have list of products and their total quantity. all i am trying to do is take a product and if the total quantity is 10, create 10 records so i can assign a unique number to each product. Example of data i have: <tbody> 2018...

I need to change my ERP system to a serialized inventory system, i have list of products and their total quantity. all i am trying to do is take a product and if the total quantity is 10, create 10 records so i can assign a unique number to each product. Example of data i have: <tbody> 2018...

Hi all, I got 1 pivot table showing Sales in the top 10 selling stores (rows) and top 10 selling products (columns) These numbers are based on 2017 numbers and i used the value filter to find make the table. I would like to compare how the same top 10 stores and products from 2017 are...

Hi, I have a list of products all with a current price and a was price. I have a separate sheet which contains the history of all of the pricing on the products and I want to find out from that list, when the was price I have was live. The trouble is for some of the products I have 8 or 9...

Hi, Is there any way to create a 2 dependent drop-down lists off of one primary drop-down list? I have States, Counties, and Products as the columns. Products are the same across all counties in the same state. I've create a name range linking States and Counties. How do I link up the...

Hi, I've got a spreadsheet of product data. The data is product part number, description, supplier name and various other product attributes such as lead time, cost, supplier contact and email address, etc. There's some gaps in the data, e.g. I don't have lead time for all products. I would...

So, I have this spreadsheet that shows a whole list of products up for liquidation, it’s been altered from an original system export spreadsheet to provide better details about each product, BUT because these products are selling, the master export report keeps changing. What I’d like to do is...

Hello, I have searched the threads and cannot find the solution that fits my situation. I have a worksheet with a data validation drop down menu in E3. This list is comprised of four types of services: Service 1, Service 2, Service 3, Service 4. For each service, there is a unique set of...

I am converting a product planning sheet from a very manual sheet to a much more automated system. I have a customer/product matrix setup a little like below, where a '1' indicates if the customer takes the product or not: <tbody> Customer 1 Customer 2 Customer 3 Customer 4 Product A 1 1...

Hi Guys, First of all, I would like mention that my knowledge in Excel formulas is limited to basic functions. My request might seem easy but I could not figure it out. I have two dropdown lists. The fist one is straight forward and gives a list of equipment. The second one is dependent on...

Hello, I try to calculate total amounts with SUMIFS. Sheet Products contains name of products, category of products, release and end date of products and amount information on rows. Sheet Amounts is used to calculate total amounts based on categories. I have couple different criteria and one...

Hi Everyone, I would like to know if it's possible that is, on how to make a cell autofill information from a list on another worksheet. I have a worksheet called "PRODUCT LIST", they all have a SKU (alpha numerical code) depending on the supplier.. example... one supplier, the code all...