derived

  1. D

    I would like to either populate a cell value from direct key input or have the cell value derived from a formula.

    I would like to either populate a cell value from direct key input or have the cell value derived from a formula. D6 is the first OFF on image. I have tried using this formula i got from another forum and modified it for what you see above, but when i use letters like OFF it doesn't work can...
  2. J

    Very strange SUMPRODUCT failure to return

    Hi All, I have a code that works great for returning information from cells that contain numbers derived from formulas, but not when one of the values can be "" or NA(). The code is =SUMPRODUCT(($G$6:$M$9)*(F6:F9="butter")*(E6:E9="low")) The layout looks like: <tbody> high eggs 33 31 38...
  3. S

    Pivot table : Calc field to derive difference in dates - unexpected results

    Hi, Hope you can help me with my first post. I have 3 columns which contain user name, start date + times, end date + time. What I want is the lowest start date and highest end date, and then to calculate the difference and show that in hours and minutes. I have a lot of data so I am using a...

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