performed

  1. J

    Formula Help

    I have a sheet I created and mind you I am no expert wehre I have personell listed in a calendar type sheet in the left colums I have names and the top corresponds with the date there are certain duties that need to be performed and I have a number key for each duty so if on one day they have...
  2. S

    Finding last occurrence cell of a multiple partial text in a row and retrieving contents adjacent to that cell

    Finding last occurrence cell of a mu <tbody> Item Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY 45685 2-Jun-2019 Submitted (Jansson [Requestor]) 4-Jun-2019 Submitted...
  3. J

    VBA coding for multiple worksheets?

    My question for the board is, does VBA coding offer a bettermeans of capturing data and performing calculations such as averaging based acrossmultiple worksheets? I have created aspreadsheet that records scores of tasks performed by task type and state over19 weeks (one worksheet per week). In...
  4. A

    Looking through workbooks to find a cell value

    I have a situation and need help. I need to lookup through multiple workbooks for a range of cells say(A2:A10) and I found the cell value in column C of any of the workbooks then a vlookup will be performed basis cell value else workbook will get closed. Please help.
  5. N

    Subtotal for Calculated Column in Power Pivot Table

    I want to sum the results of a calculated column in a PowerPivot calculation but the calculation is actually being performed on the subtotals also - is there a way I can change this? The calculation is TargetMet=IF([Sum of Actual Income]>=[Sum of Planned Income],1,0) I would like the subtotals...
    • ndbennett
    • Thread
    • calculated calculation column performed subtotals
    • Replies: 3
    • Forum: Power Tools

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