max()

  1. OHB

    Retrieve previous row Record to subtract from current row above (water consumption)

    Hello all Members of the Forum, I built a query where I want to calculate the difference between two rows in the same column. The previous Record is deducted from the next record just the row above and the difference between both value appear in the result of another column (same row). My...
  2. T

    Pivot table calculated field with MAX() doesn't work as expected

    I am trying to count how many resources it takes people to complete various tasks. I am using a pivot table because the data table is huge, over 2000 rows for 600 people. I need to know two pieces of information, for each person: a) AVERAGE: the average resources of each type used for each...
  3. C

    VBA Variable equal to formula with if() Max() Sumproducts() of Ranges

    I've got several formulas that work in cells of the active sheet and I reference them from VBA code to create ranges. I'm trying to get the formulas out of the sheet cells and into variables in VBA that I can use for a range references. The first step is to find the starting point for the first...

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