CAN SOMEONE HELP
HERE IS MY DATA
A B C D
Name CofC Date FDAOTMR
B------ PHIL17-Aug-0617-Feb-0617-Aug-06
COMPLETED 10-Jan-06 15-Jan-06
B------- BOB30-Aug-0628-Feb-0630-Aug-06
COMPLETED
B----- Steve05-Mar-0605-Sep-0605-Mar-06
COMPLETED
B----- Dave14-Dec-0614-Jun-0614-Dec-06
COMPLETED
B----------- Wayne10-Mar-0610-Sep-0610-Mar-06
COMPLETED
and so on
column c and d are activities the person has to complete and the date under
this is the latest it has to be completed, along the completed rows are the
dates they were completed. What i have it doing using cond format is
background goes black of the cell if within 60 days and yellow if it has a
completed date in.
what i am after on a seperate sheet is a list of all that are within 60 days
and not been completed
like this
B------- BOB 28-Feb-06 FDA
B----- Steve 05-Mar-06 OTMR
PLEASE HELP
- Jul 16 Mon 2007 20:38
list on new sheet
close
全站熱搜
留言列表
發表留言