brand

  1. D

    Trying to create a simple price list from a table is driving me nuts...help needed please!

    Hi All, I have a problem. I'm no Excel expert which is why I've come here for some help. I have a price list, a snapshot is below, which is divided into three columns; Brand, Product, Price. What I'm trying to achieve, and so far failing abysmally, is the ability through a drop down list to...
  2. G

    Return value from cell when lookup data is in an array

    I have a lot of UPC codes that are listed in an array A1:H300. In Column J is a product's brand name associated with the UPC codes from that row. I am trying to return the brand name in another workbook by looking up the UPC from the array. I just can not figure out how to do it and I...
  3. F

    SUMIF with multiple criteria

    Hi Everyone! Long time lurker, first time poster. I'm hoping someone can shed some light on a problem I'm facing with a summary sheet. I have a large set of data that includes: brands, employees (that may or may not work under multiple brands) and their commissions earned from each brand. Ex...
  4. Y

    Problem with choosing multiple item under selected field in pivot table (using VBA)

    I have problem to code macro to select multiple item under a particular field in pivot table. The criteria for the item being used is coming from a table in another sheet (brand) Brand Brand Cde AAA BBB CCC BIO BCL PivotTableSheet (pick some sample...
  5. J

    Count Distinct Values for 2 criteria in Excel using VBA

    Hello I am new in VBA and I am looking to build a macro to count the number of stores a responsible (let's say K) sells to, for each brand. In this example, K sells to 1 store the brand 1 and 1 store the brand 2. (so a total of 3 sales but to 2 stores only). Any help would be really appreciated...
  6. R

    I need help to make conditional formatting formula vba

    Hi, I need help to make conditional formatting formula vba code, PFA excel file Main file and output file download file from http://pikkaa.com/excel/ I have one column (brand) and one is (Small image column) I have data in two cell seprated by | need copy that in saprate rows while...
  7. S

    VBA: Type 13 Mismatch - Not sure what could be wrong with my variables.

    So alot of this code is comented out. So it's pretty clear what is going on. But I'm having an error thrown in a section of the code I just added. What's confusing about it is that it worked fine in the section of the code I added when it was independent. I have the section of the code...
  8. S

    VBA: Is there something wrong with the way I am defining my variables here?

    Hello, Can someone tell me if there is something wrong with the way I am defining my variables here? I'm not clear on what it is. Sub Insert_Map() 'We are inserting our variables Dim rngMSRPHeader As Range Dim rngHeaders As Range Dim brand As String Dim mapPolicy As String...
  9. B

    vlookup Tractors

    I want to create page using a filters data as it proceeds. the end result is a means for our salesmen to find the purchase price of different models of tractors. Ideally, the person will select the brand of tractor, then using the next box, select the particular make. (up to 30). After...
  10. S

    Index Match - Multiple Criteria with a date range

    Hi All, Hopefully the title is quite descriptive here, I'm essentially trying to do as I describe; I'm trying to do an Index Match with a few criteria, one of which is a date. Here's an example below: The formula will sit in an excel sheet which will be completed with the following...
  11. I

    How to compare two Excel files for differences

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

    excel pricelist to excel import layout converter

    Hi all, I hope anybody can point me in the right direction of the challenge I'm faced with: Periodically I have to convert excel pricelists that I receive from suppliers to an excel pricelist according to a layout that can be imported in our system. Currently this requires lots of manual labor...
  13. P

    reference a cell within a cell reference

    Hello All, Can someone please tell me if it is possible to reference a cell within a cell reference. I have the following formula and would like to be able to reference a brand # (refer to the blue highlighted text) by placing the text "Brand '#02" into a cell and then reference ing this cell...
  14. M

    Interactive Form

    Hi, I work in a grocery store and I am trying to make a Spreadsheet file to send to my employees that will organize the information related to the products they want to put in our weekly advertisement. I need a brand name and the number of items from that brand that will be on sale and the...
  15. B

    Subtotal in Pivot calculated field

    Hello, Is there a way to display Grand total in calculated field in PIVOT in columns (but display grand total of rows)? This grand total should show TOTAL value of all visible (filtered) values. I will then use this calculated field in PIVOT chart to display total planned sales of certain...
  16. L

    Pivot tables with multiple date columns

    Hi there, I'm trying to work out how to create 2 different pivot tables from the one table. Here is an example table below: <tbody> Product Brand Category Jan Qty Jan Sales Feb Qty Feb Sales Mar Qty Mar Sales Item 1 Brand 1 Cat 1 5 $500 4 $400 7 $700 Item 2 Brand 2 Cat 1 20 $50 30 $75 10...
  17. Y

    Conditional Standard Deviation

    I wish to calculate the standard deviation of Brand A Product 1-5 and Brand B Product 1-5. Is there any shortcut for this? I call this a brand pairing and I have 300 brand pairing to be done. Help is needed! :( <tbody> Brand Product Demand A 1 3 A 2 4 A 3 12 A 4 35 A 5 6 A 6 8 A 7...
  18. A

    P&L lookup to be done through formula for data segregation

    I have to segregate a consolidated P&L, in which I have PY, CY, BUD for one brand followed by another brand and there are almost 50 brands. What I have to do is I have create a master table where in I will put in the Brand name and it should reflect the information for that brand. G1, H1& I1...
  19. E

    Worksheet_FollowHyperlink not working - even in brand new file

    Hello, I need a hyperlink to open a macro, but I am not able to get it to work. At first I thought it was the larger code it was a part of, but I have tried both of the bare bones codes below to get a hyperlink to open a macro and it is not working. I have even tried closing all other excel...
  20. C

    Cross Purchase Help

    Hello, I am trying to get at some cross buying behavior from a large data set that I have. Here is a simple, example of the data I have: <tbody> Name Product John Brand A Mark Brand B John Brand C Amy Brand A Amy Brand D Amy Brand C </tbody> And then this is my desired output...

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