1. P

    Advanced Userform/ Input box

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

    Specific LookUp Value

    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]...
  3. K0st4din

    Macro or formula- the same products, but a different sales color, looking for SUM

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

    SMALL function to show top 10 smallest values with their names

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

    Variable range based on data from a cell

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

    Pricing problem in Excel

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

    Find Duplicates in column and extract rows

    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"...
  8. M

    ActiveX ComboBox to drive workbook presentation

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

    Showing different scenarios in Excel

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

    Count comma separated value with one of criteria in between commas

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

    Managing a large amount of data

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

    Multi-sheet Pivot Table

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

    Pivot - how to show items with no data if I have 2 row categories

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

    Bundling Products - need help with a quick way to pick which products to sell together

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

    Index name of a product

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

    Vendors who supply multiple products

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

    Matching Data

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

    Products se vba to sum qty

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

    Formula to change the ref number in a coulmn once all of them have been used

    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 "...
  20. K

    Need Data converted using specific set criteria

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

Some videos you may like

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back