Here's a doozy

  • Thread starter Thread starter Wilson
  • Start date Start date
W

Wilson

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.
 
Hi

Data>Filter>Autofilter
Select the dropdown on column A>Custom>Contains>"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
 
Back
Top