Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to capture historical data from data that changes daily
I'm hoping somebody out there can help me. Please refer to below scenerio.
TITLE % of Budgeted HOURS Completion % PROJECT TOTAL 100.00% 90.00% (the above is updated from 4 other sheets) SIT Test Time Tracker Today 28-Dec-05 [using =now()] Start of Final SIT 9-Jan-06 End of Final SIT 6-Feb-06 [I want Col B and Col C to refernce the "today [=now()]" above and the dates in their respective rows below to capture the "PROJECT TOTAL" information above. I can use "IF" but once the "Today" dates change to the following day the data will be lost and only the currents info will be present. I want to capture historical data to graph. Thanks for your help in advance!] Col A Col B Col C % of Budgeted HOURS Completion % 9-Jan-06 10% 20% 10-Jan-06 30% 40% 11-Jan-06 50% 50% 12-Jan-06 70% 65% 13-Jan-06 85% 75% 14-Jan-06 95% 85% 15-Jan-06 100% 90% 16-Jan-06.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Formula to capture data on a date and preserve it | Excel Worksheet Functions | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |