Home |
Search |
Today's Posts |
#1
|
|||
|
|||
extract name when a date in another cell gets near
Can someone help please
this is how the database looks A B C D E F G H 1 Surname First Formal Driving Ass OTDR Interim 2 Earliest Latest Earliest Latest Earliest Latest 3 Anyone A 18/05/05 17/11/05 18/05/05 17/11/05 18/11/05 17/05/06 4 18/06/05 20/01/06 etc with other names A3/A4 HOLD NAME IN MERGED CELL, COMPLETION DATES ENTERED ARE SAME c4/d4 etc Now a date is placed in row 4 when the assessment was completed, as you can see under OTDR there is no completion date entered and the 17th November is getting close (within 45 days of latest date) so what i would like is on a different sheet the name and the assessment (in this case otdr) to go on a list but there could be more than 1 assessment needed for the same person (it would be ok if name appears twice in list with appropriate assessment). Then i could print list off so i know who needs to be assessed. Now this next bit could be complicated, in addition to the above, on the left of the list i would like names and assessments within 7 days to be completed and on the right, names and ass within 45 days to be completed but not appearing here if the same name and assessment is on the left side Hope someone can help |
#2
|
|||
|
|||
extract name when a date in another cell gets near
Take a look at Data Filter AutoFilter...........and play around with the
"custom" criteria, such as "greater than" or "less than" etc..........should give you something similar to what you're looking for...........post back if you have difficulties with it. Vaya con Dios, Chuck, CABGx3 "cityfc" wrote: Can someone help please this is how the database looks A B C D E F G H 1 Surname First Formal Driving Ass OTDR Interim 2 Earliest Latest Earliest Latest Earliest Latest 3 Anyone A 18/05/05 17/11/05 18/05/05 17/11/05 18/11/05 17/05/06 4 18/06/05 20/01/06 etc with other names A3/A4 HOLD NAME IN MERGED CELL, COMPLETION DATES ENTERED ARE SAME c4/d4 etc Now a date is placed in row 4 when the assessment was completed, as you can see under OTDR there is no completion date entered and the 17th November is getting close (within 45 days of latest date) so what i would like is on a different sheet the name and the assessment (in this case otdr) to go on a list but there could be more than 1 assessment needed for the same person (it would be ok if name appears twice in list with appropriate assessment). Then i could print list off so i know who needs to be assessed. Now this next bit could be complicated, in addition to the above, on the left of the list i would like names and assessments within 7 days to be completed and on the right, names and ass within 45 days to be completed but not appearing here if the same name and assessment is on the left side Hope someone can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update cell based on date range | Excel Discussion (Misc queries) | |||
Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Extract date from cell | Excel Worksheet Functions |