related values

  1. P

    Power Pivot Lookup Duplicate Values

    Hi, I am using Excel 2010 with PowerPivot add-in, very much a newbie in Power Pivots. I have a set of shipment data compiled from various sources. They have to be cleaned and grouped into lanes. For the purpose of cleaning the origin and destination points I have a list of all variations of...
    • prihle
    • Thread
    • lookup power pivot related values relationships
    • Replies: 3
    • Forum: Power Tools
  2. D

    Replacing a single row in a table with multiple related values

    I am trying to break down the following 2-column table to include only each 'FinishedGood' and all its 'Inventory Parts' broken down to the 'Component' level. I want to replace each 'SubAssembly' Inventory Part with its corresponding 'Components': Source Format: <tbody> Assembly Item...
  3. potts

    Pivot table issue

    Hi I want to create a pivot table that shows the maximum weight athletes squatted in the gym each month and the maximum number of reps they did with that weight. The raw table headings are: NAME DATE SQUAT SQUAT REPS I have managed to group the date data to get the max weight lifted each...

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