Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's a doozy
I have a table of data. In column A, I have the names of tasks and in column
B I have their expected finish dates. I need to find only those tasks that have the sub-string "Execute Assembly Test" (approx 107 tasks) and then determine, based on column B (expected finish), the date that we can expect 90% of those tasks to be complete. Can anyone help me, I'd like to attempt to do this in an efficient a way a possible. Thanks again. ***I would prefer to not have to paste data into a new column and then do calculations of those values, but I'm not certain there's any other way. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Here's a doozy
Hi
DataFilterAutofilter Select the dropdown on column ACustomContains"Execute Assembly Test"OK You will have a filtered list of your tasks. Insert a new row above the header row and in B1 enter =SUBTOTAL(1,B3:B1000)+1.2*(SUBTOTAL(8,B4:B100)) adjust the ranges to suit Subtotal(1,rng) gives the Average Subtotal(8,rng) gives the Standard Deviation Somewhere around 1.2 Standard Deviations above the mean will cover around 90% of the values -- Regards Roger Govier "Wilson" wrote in message ... I have a table of data. In column A, I have the names of tasks and in column B I have their expected finish dates. I need to find only those tasks that have the sub-string "Execute Assembly Test" (approx 107 tasks) and then determine, based on column B (expected finish), the date that we can expect 90% of those tasks to be complete. Can anyone help me, I'd like to attempt to do this in an efficient a way a possible. Thanks again. ***I would prefer to not have to paste data into a new column and then do calculations of those values, but I'm not certain there's any other way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ready for this? It's a doozy! | Excel Discussion (Misc queries) | |||
This is a doozy... | Charts and Charting in Excel | |||
This is a doozy... | New Users to Excel |