I have a table with loads of columns. they all have a unique ID (A). In one column (K) it says a date that something was meant to be completed, in the next column (L) it says when it was actually completed. I am trying to do an analysis and show how many of the Projects (A) where delivered on time.
I work for an Insurance company and i'm running into the following problem:
I'm trying to standardise 'free-text clauses' in our insurance system, clauses for insurance products which, for one reason or another, were not entered using a standard clause...
I am thinking about applying a what-if analysis to find out the one time cost for a LED bulb but I am not sure if the what-if analysis should have a two variable (separate fixed and variable cost) or a one (only variable cost) and how I formulate such a what-if condition.
I am enclosing a...
I am in dire need to analyze some sales figures for a lot of different products to identify which ones have similar sales pattern over the course of a 12 month period. No regards to volume, only sales pattern over 12 months is interesting. I need the products with similar patterns to be...
I created the following code to make calculations and then copy the results in the "Cash Flow" sheet. It takes 15 seconds but I'm sure that the code can be optimized. In step 1) formulas are applied to a range of cells in "PTF" sheet; step 2) change the date and the formula are...
How to integrate contents of rows as headers in values field of pivot table.
Please find the attached to understand the question better.
Thanks in Advance