Solved

# Daily Dynamic Target Calculation-2

Posted on 2014-03-05
106 Views
Hi byundt,

When the actual values filled for only few days of the month, the target still calculates for the remaining days too.

But it considers '0' for the days where there is no input, So the dynamic target for the dates where the input is not put. Is there is anyway to optimize this.
DynamicTargetCalculations-v3.0.xlsx
0
Question by:sunil1982
• 4
• 3

Author Comment

ID: 39907592
It should pick the average of the filled values for days which has data  and compare with target.
0

LVL 29

Accepted Solution

gowflow earned 300 total points
ID: 39909184
Is this what you want ?

I made it in a way that if there is no value in row 3 it will not calculate.
Let me know if it is correct.

gowflow
DynamicTargetCalculations-v4.0.xlsx
0

LVL 29

Expert Comment

ID: 39909231
I read your post again and looked further on the data and noticed that maybe I was mistaken.

You meant to say if Row 2 has limited amounts not covering the whole month you need ... ?? what ??

K and L that have no values on row2 what do you expect the result of the formula on row 4 and 5 for these 2 columns K and L

gowflow
0

Author Comment

ID: 39913684
In the mean time,

What I did  is

1. Averaged the reported values ( Examples for 10 Days).
2. Subtracted it from the target...
3, Then divided that with number of NON-Reported days
4. Added that value to each days target..

I will post the excel here soon...
0

LVL 29

Expert Comment

ID: 39917538
still waiting ...  ur soon ... still not showing up !!!
gowflow
0

Author Comment

ID: 40113701
My solution haven't worked well...I am still in search of a solution...
0

Author Closing Comment

ID: 40219463
Thank you
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.