chair

  1. E

    Pivot table subtotals for certain fields

    Hello, Using Excel O365. Have created a pivot table and added subtotals as below. I want the subtotal on the MOQ field (and others not showing in the sample below) but I don't want the subtotal on the selling price, cost, margin fields as they are nonsense fields. How (if you can) switch of...
  2. S

    Itemising individual items from a totals table

    Hi, We have a table that a list of furniture types in it and the total number of that type in each room in a building. I want to be able to create a list that itemises every piece of furniture individually. (Although furniture may be the same type they may have different finishes and therefore...
  3. T

    Lookup and return all values in a row

    I have a table that follows the same structure as below. Note that in my document it is a very large table (150 rows, 30 columns), so I would like to keep the general formatting of it. <tbody> Bob Table Peter Bed Couch Chair Jeff Bed Table Grace Couch Chair Tom Bed Couch...
  4. B

    Data Validation - Show values in drop-down based on another cell

    Hi, I am running into the issue that my drop-down list becomes too long, because there is too much data to work with. We make an export out of an ERP system, which gives us 2 columns(let's call them Columns Chair & Desk) and about 3.000 rows of data. As you can imagine, multiple chairs go...
  5. B

    Extract Multiple Leadership positions from a list for the same person

    I have a list of members where some hold more than one position. If I use a regular Vlookup or Index Match formula I will only get the first one and will be repeated. For Example, Jane Doe is a president , secretary and bargaining chair. I have 3 records in my list where I would expect to...
  6. proficient

    Multi index match with find or search function

    Hi all, I have a table containing receipt (Column A) amount (Column B) description (Column C). The most important thing is that the receipt multi receipt numbers but by description cloumn we can identyfy as if one receipt # used to purchase chair it won't be use to purchase chair again...
  7. C

    Vlookup based on multi search

    Hello Team, Could you please help on vlookup formula based on multi search <tbody> Desc Formula Output this is chair 1 apple on the tree 2 Chair broken 1 Fresh Tomoato 3 <tbody> Vlookup Search Desc Code Chair 1 Apple 2 Tomoto 3 </tbody><colgroup><col><col></colgroup>...

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