product

  1. M

    VBA - Push column I data down depending on F

    Hi - I have a report that spits out false info. Due date (F) populates 2 dates. In this case there are 4 x 27/06/19 that shouldn't exist. This in turn means the WIP Qty is 4 numbers short (I). How can I push (I) down everytime it finds the wrong date? That would also depend on Job # (C) being...
  2. T

    Addition formula in a single cell

    Hi there I have a four product code (i.e r,p,E,Y)in cell range A1:A4 and the price for that product is mentioned against each code in cell range B1:B4 (i.e 6.87, 9.18, 10.54, 22.73). I am seeking for a formula for following purpose if i enter multiple codes in a single cell (say Er,Yp,EY, EE...
  3. S

    Calculate the selling price of a product

    Hello All, I am trying to build a template to calculate the selling price of an item given the various costs. Assuming I buy a product for $10.00, I expect to make a 10% profit Margin so technically I would need to sell it for $11.00 So far I can handle it, the issue is that the platform where...
  4. 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...
  5. E

    Double Donut - Need Help!!!

    Good afternoon all, I'm struggling with a double donut chart. I know exactly how I want it to look in my head, but when I create it on Excel, it doesn't look the same! I have a number of products, in a number of regions. For instance: Product A has 10 in Region 1, 10 in Region 2 and 0 in...
  6. B

    SUMIF a range with a ISNUMBER SEARCH criteria

    Hi! I am trying to sum up a column that has different product names. For instance a Batavia Grand Vista and a Gazelle Grand Vista both have a sales value and I am trying to sum up all the Grand Vista's. I found a formula using SUMPRODUCT combined with ISNUMBER but I can't get it to apply to my...
  7. M

    index match match - VBA code loop ignore if cell contains data

    Hi, Apologies.. this might be a bit vague, I'm looking for suggestions if possible. I will have a large matrix - may be 200 x 1000 To simplify the above, imagine I have a matrix of 3 x 3. Across the top (as headers) are account numbers. Down the left side are product codes. On sheet 2, I...
  8. H

    Search product price by latest date

    Hi everyone! I am new here in the forum and I looked for some solution to my problem and I did not find anything similar, so I decided to create a new post. I have a workbook with two worksheets "STOCK" and "SALES REGISTRATION". In Stock, I give all of my products that I buy to sell...
  9. P

    Help with the basic formula

    Hi everyone <tbody> Product wholeseller price/kg Apple ABC Rs 50 Orange ABC Rs 30 Apple XYZ Rs 40 </tbody> Using Product as the key i want to extract all the datas in new table like <tbody> Product ABC(Price) XYZ(Price) Apple Rs 50 40 Orange Rs 30 </tbody> I used formula to get...
  10. J

    Pivot Table to Pivot Chart

    Hi! I'm trying to create a chart that allows you to filter dates and product values. I tried making a table directly from the chart options but found that annoying so resorted to doing it from a pivot table date. I have what I thought was a simple range of data, just weekly dates in column A...
  11. K

    macro beginner

    hello all, i'm a beginner of macro i want to create a form template to record guest inquiry, trying to write some code on textbox(es) to speed up my daily progress however i get stuck with below issue, hopefully someone can help me out, superb thanks the data will be saved into sheet2...
  12. B

    Look-up from 2 excel files.

    Hi Everyone, I'm using this formula to get item name from another excel file when I enter the item code. Am wondering if it's possible to search in 2 files and retrieve the item name. Item code will be in any of the following file. Product Master.xlsx or Archive Product Master.xlsx...
  13. S

    Find cell value using multiple criteria and a header row that does not always have a value

    Hi everyone, I've been racking my brain and many google searches later and have been having a really hard time at this. I would really appreciate some assistance! I've got a file that has a layout like this: <tbody> Product Country 1 Product Country 2 Product Code 1 Product Code 2...
  14. M

    Formula to identify / remove duplicates based on one column

    Hi I've got three groups of data over 9 rows. Each group has duplicates and I'd like to delete the duplicate rows based on data in column C, which has Cash Sales. In the table below, column A has Product IDs, column B has Product Names, column C has Cash Sales and column D has the Group...
  15. D

    Query - Filter out multiple bar codes to show only 1 bar code per product.

    Hi! My query is this - I have 3 columns. Barcode | Product Type | Product Name | Colour 1234567890123 | AAA | Example1 | White 1234567890124 | AAA | Example1 | Black 1234567890125 | AAA | Example1 | Red 1234567890126 | AAA | Example2 | Purple 1234567890127 | AAA | Example2 | Orange...
  16. M

    Checkbox and conditional format

    Hello! Once again I come to you guys in hopes of finding a solution to my problem. I have this sheet where it shows a list of our clients. We have about 13 offerings(products) and I want to color code them, so that when I look at client 1, I can see they show red and blue so that means they...
  17. W

    Combining Duplicates

    I have a sheet downloaded from a website. Column A is the product IDs. For some reason the site splits the data for some products into 2+ separate rows. I already formatted the duplicates and sorted them but I still need to combine all the data for each product into one row (sum). I need the...
  18. U

    one pivot table from two different excel table

    Hy Everybody, I am sure somebody can help me: I have an Excel Table with Price Data - Product Name, Quantity (piece, weight, etc), Price in Dollar, Price in Euro. I have an additional Excel Table with 7 Sheets (one weekday each), with Product Name, Company, Sale My Question is, how can i make...
  19. samilynn

    Fluid VBA macro?

    I'm working on a macro with a lot of steps for a file that needs to be recreated on a regular basis. Is it possible to have the macro modify the range in the formula each time, based on how many rows are populated in the file? (the spreadsheet doesn't always have 738 rows of data). The formula...
  20. D

    Aggregate Function's Array Argument Gives VOLATILE formula result when using concatenation for Named Range

    Need experts help on this after racking brain over and over. I have a data sheet, 'DATA', that contains Product and Pricing detail by row. Each row will have a column for Product Name (ie. Product A, Product B, Product C....etc), and a column for Location, (ie.Location 1, Location 2, Location...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top