Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |