products

  1. A

    Transposing and clearing cells to tidy up data

    I’m hoping someone can help – I have used text to columns to split out products that had been entered into one cell and were separated by a comma. I then ran a macro to duplicate the rows based on the number of products to give each product its own row of data. But now I’m stuck as I don’t know...
  2. S

    INDEX + MATCH + MAX Question

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

    How to take last data entry of previous product and substract from current product?

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

    Find Missing Values

    What i am trying to do is we have multiple accounts and products, would like to find the missing products for each account. I saw solutions for matching one set but not multiples Account Product 1 Apple 1 Orange 1 Tomato 2 Orange 2...
  5. P

    Index match or find the maximum matching value

    Hi All, I am trying to design a formular, I have a list of products with its descriptions. Also I developed a function called similarity which determine two cells similartity %. So Now I have a list of new products and old products list with its functions. Is it possible in B15 and B16 to use...
  6. D

    Transfer Multiple Rows Data in Single Row Excluding Blanks

    Hi All, I have the data of Product in Row A and its price in row B. Similarly Product in Row C and its price in row D. in Total having 3 list of products and prices. Maximum 10 entries user can enter in each row. I want all the products from those 3 rows in single row G and its price in H...
  7. E

    Company name list

    Hey guys, so basically I have a list on the left of companys (company a, company b as example) and list of products for each company (P1, P2, P3) and the revenue Now I need something like the right hand side where all the products for each company are in a single cell (or even how to have...
  8. Nelson78

    Dictionaries and vba: when to use

    Hello everybody. I've been studying some of the solutions found in mrexcel.com about dictionaries. Having applied them "blindly" to my issues with success, I've decided to understand better their dynamic. Suppose I've a table like this: https://imgur.com/h2sfGql How can I build a dictionaries...
  9. C

    showing the total number of products not just if they have it

    HI All I regret that In my job I don’t get to do as much work with reports as I would like as I just keep forgetting some of the basic stuff never mind the more complex formula’s and strategies. I have a sheet called raw data that shows the company name and products that our customers have...
  10. J

    How do I get a total count?

    I have two products and I need to know how many passed. Is there a way without doing a macro? If so, how? Thanks ahead for any help and suggestions.
  11. J

    Restructure of data using array formulas

    Hello, I have the following data: <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5 " /><col /><col /><col /><col /></colgroup><thead><tr...
  12. D

    Do While/ Loop

    Good day all, I have a command button titled "LOW STOCK" on my userform, I want the back color of this button to switch between yellow and salmon when Cell G3 > 0 (Cell G3 contains number of products below stock minimum limit). The blinking will prompt the user to click the button inorder to...
  13. S

    Condition query

    If I have a filter in a pivot showing top 5 products - is there a way to see what other top 5 products were sold when those top 5 were sold also?
  14. S

    Data loss when deleting filtered rows

    Hi all, I've got a macro which appeared to be working perfectly, however when I ran the data without any of the products to be excluded I found that I was losing EVERYTHING :confused: I've narrowed the culprit down to this: 'Remove excluded products Sheets("Consolidated").Select...
  15. M

    count duplicate rows

    <tbody> Product Lot Exp A 1 X A 1 X A 2 Y A 2 Y </tbody> need function that will allow me to count different products with different lots from a list.
  16. T

    Ifs & and

    Hello. First of all, thank you very much for taking time to review the below case. So I have a data set and I'm attempting to build a formula with IFS and AND to determine the following; New Customers: customers who have never purchased any of the selected products. Returning Customers...
  17. P

    What have the clients NOT purchased?

    Hi Guys, Been a while. Got one that I cant quite get right in my head how to do it. I have a list of clients and the products they have purchased. Client table: <tbody> Client Name Products Users Fee Mr PROD1 5 100 Mr PROD2 1 100 Mr PROD3 3 100 Excel PROD1 5 100 </tbody>...
  18. 1

    Using OFFSET, SUMPRODUCT & LEFT in a formula

    I have created this formula to look at data that is coming from an AS400, to sum up, production hours. I am getting a value error when I start using the if statement in the formula. Without IF in ReportB4...
  19. A

    Sorting an excel datasheet

    I can't seem to sort the excel datasheet in the right way. It needs to be in a particular way so the products can be merged while uploading. In the screenshot, I show you how it is now and how it needs to be. There are around 65k rows, sorting one by one isn't an option. I also provide a sample...
  20. C

    Dependent list with tables

    Thanks for your help. I have a number of Suppliers and I have listed the products they supply under the Customer name. I want to be able to choose a Supplier and have the output generate the list of products for the Supplier. I would also like to get the output to display 2 other features: a)...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top