-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
derived
-
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...- delos
- Thread
- derived direct formula input populate
- Replies: 14
- Forum: Excel Questions
-
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...- JoeJackson12
- Thread
- #na error derived formula low sumproduct
- Replies: 8
- Forum: Excel Questions
-
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...- scoobster
- Thread
- date derived difference pivot
- Replies: 2
- Forum: Excel Questions
