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.

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.