multiple row

  1. A

    Looking for help with hlookup and concatenate or index match (newbie)

    I have a data sheet like the below and i want to for each row find the corresponding X and put it into the the below. I'm not savy with VB and my work computer has Excel 2016. Thanks for the help. <colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>...
  2. Z

    VBA Pivot Table : Output / Concatenate multiple row Data into a String depending on a Value

    Hello all, I am trying to implement the below concept in VBA: I have a Pivot Table that has the data below ( I am actually viewing the data in tabular form, but this is arbitary) Lets call this Pivot1_1 <tbody> Toy Region Country Toy1 Region1 Country1 Toy1 Region1 Country2 Toy1...
  3. F

    switching rows to columns and removing multiples with variable row count

    Hello, I would love o get some help with this problem, since it was quite some time i used excel for more than summing things up. So - I've got a table with about 1000 rows, and four columns. The first column has the ID of a place. The second column has the name of that place The second...
  4. T

    Return Multiple Items XL07

    Good day! I am having quite a bit of a run in with this formula. I think I have it down but the information that is being pulled is the wrong information. Background: I am making a letter on excel for people, that will have information presented at the bottom of the letter, that is pertinent...

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