structured

  1. D

    Structured References between workbooks

    Is it possible to use structured references between workbooks. I have a data work book which is pulling data from a table in a master sheet using row / column references and this is causing me an issue if a column gets added in the master sheet and I want to use structured references to get...
  2. O

    Match Multiple Criteria Structured Reference

    Hello. I have two named tables LaborForecastHours and LaborForecastCost. I want to cross reference two columns [Task] and [Employee Name] (same in both tables) using a Match function to return the row in LaborForecastHours that matches the current selected row in LaborForecastCost. I've tried...
    • ocean007
    • Thread
    • formula match #value! reference structured structured reference
    • Replies: 2
    • Forum: Excel Questions
  3. C

    Learn VBA

    Hi, I want to learn VBA but I do not know where to get an organized / structured learning environment? I have taken few online Excel VBA classes. All of them just taught me to "Record" steps in macro then go from there. To me, that is not helpful. Could anyone suggest books, online classes, or...
  4. D

    Create History List

    I've been looking for a set of macros I could use to put together to keep track of items I order. I want to take the data from one worksheet and mesh it together into a history worksheet on another. Basically to keep track of how many of an item I buy by date and add new part numbers as...
  5. A

    Power Query Change “shift cells down” to “insert row”

    Hi When Power query tables return more (fewer) rows than previous it shifts cells down (up) below the table. I would instead like Excel to insert (remove) an entire row. This is because of the way the rest of my workbook is structured. Is there a way that I can select or effect this behavior...
  6. M

    Conditionally Formatting using SUMIF in a structured table

    I'm banging my head against a wall here. Can anyone help? Bascially, I've got a structured table where the last x# columns are week ending dates for staff and the user will fill out hours in each column for each staff member. However, the trick is that each staff member may be on multiple...
  7. M

    Calculated column with structured reference and range not automatically updating

    I'm having trouble getting the following formula to auto complete in a calculated column =([@[Commercial Net]]-MIN(BV423:BV579))/(MAX(BV423:BV579)-MIN(BV423:BV579))*100 Whereas formulas that only include structured references work perfectly fine =[@[Commercial Positions-Long...
    • MoshiM
    • Thread
    • =[@[commercial calculated column formulas structured
    • Replies: 0
    • Forum: Excel Questions

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