chicago

  1. I

    Sumifs?? Left?? Dish sales

    I'd like to sum all of the dish sales based on the Location number and Product IDs. Can I do this without creating a helper column? <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Location Product ID Product Desc Sales 2 555652 Houston 10047108 Dish 12" 4 3 555652...
  2. S

    Get Count of Unique Items Within A Designated Area

    So the easiest way to explain what I am trying to do is with an example. See the sample Data below: <tbody> <tbody> Investment </tbody> <tbody> Current/Prior </tbody> <tbody> Routine/NonRoutine </tbody> <tbody> AA </tbody> <tbody> FHLMC GOLD PL V84191 </tbody>...
  3. J

    Index/Match formula

    I am trying to pull data from one worksheet into another worksheet. I think using Index/Match is the way to go, but I'm not sure how (I tried Vlookup and don't think that's the right formula). Worksheet one has numbers in column A (say 1 to 10), and in Column C has the data (Town visited) I...
  4. N

    vloop or code - entire row

    Hello All, So I have office locations in sheet 1 as follows: <tbody> Location Address City State Zipcode Chicago 243 W Jackson Chicago IL 60605 New York 505 W 50th St New York NY 10019 Los Angeles 20 Calabasas Road Los Angeles CA 98490 </tbody> Now I m looking to auto populate data...
  5. B

    Creating Table Data in VBA

    I am building a workbook as an add-in that will provide specific site information such as address, phone, etc. I'd prefer to not store that data in a sheet, and instead would like to store it in VBA, since it doesn't change. What's the best way to do that? In an ideal world, I'd love to write...
  6. T

    Creating Duplicate Rows

    Hi all, I have a worksheet where each row represents a location. Column C lists all of the employees at that location separated by carriage returns. Is it possible for the sheet to split out the employees and display individual lines for each employee? <tbody> Location ID Location Employees...
  7. S

    combining 2 excel sheets into 1

    I want to combine my weekly reports into one master file. After I copy paste them into one sheet, I have to go through them manually to match all the rows. There can be 7000 plus rows and it takes all day to manually fix them. What can I do to automate it? V lookup only work on one column. I...

Watch MrExcel Video

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