Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
list text from a cell if condition met
Hi, I need help.
I have attendance calendar for each date it has four raws. the first raw has date second raw has input fields third raw has formulas and returns value based on raw 2 and raw 4 raw four has different text( unexcused absence, unexcused tardy etc) 1/16/06 TPU 8 Occ Unexcused Absence (Whole) What I need to do is create a formula that will look through 2006 calendar, check the date if is <365 days from the curent date and the 4 raw has "unexcused absence" or "unexcused Tardy", it will list the date for every time the above conditions meets otherwise will skip the date. So the result will look like Unexcused absence Unexcused Tardy 1/20/2006 1/23/2006 5/20/2006 Thu sI will have a list of all dates that have the each category in the fourth raw and the date in the first raw is <365 days from today. In additions as date changes the list will drop the date as it will be 365 days from the current date. I hope this make sense. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
list text from a cell if condition met
Could you diagram for us a sample of the original data. I believe that the
solution will probably involve using the Data, Filter, Advanced filter command but I will be better able to tell you when you show some sample data. -- Thanks, Shane Devenshire "DD" wrote: Hi, I need help. I have attendance calendar for each date it has four raws. the first raw has date second raw has input fields third raw has formulas and returns value based on raw 2 and raw 4 raw four has different text( unexcused absence, unexcused tardy etc) 1/16/06 TPU 8 Occ Unexcused Absence (Whole) What I need to do is create a formula that will look through 2006 calendar, check the date if is <365 days from the curent date and the 4 raw has "unexcused absence" or "unexcused Tardy", it will list the date for every time the above conditions meets otherwise will skip the date. So the result will look like Unexcused absence Unexcused Tardy 1/20/2006 1/23/2006 5/20/2006 Thu sI will have a list of all dates that have the each category in the fourth raw and the date in the first raw is <365 days from today. In additions as date changes the list will drop the date as it will be 365 days from the current date. I hope this make sense. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
list text from a cell if condition met
On Jan 21, 1:39 am, ShaneDevenshire
wrote: Could you diagram for us a sample of the original data. I believe that the solution will probably involve using the Data, Filter, Advanced filter command but I will be better able to tell you when you show some sample data. -- Thanks, Shane Devenshire "DD" wrote: Hi, I need help. I have attendance calendar for each date it has four raws. the first raw has date second raw has input fields third raw has formulas and returns value based on raw 2 and raw 4 raw four has different text( unexcused absence, unexcused tardy etc) 1/16/06 TPU 8 Occ Unexcused Absence (Whole) What I need to do is create a formula that will look through 2006 calendar, check the date if is <365 days from the curent date and the 4 raw has "unexcused absence" or "unexcused Tardy", it will list the date for every time the above conditions meets otherwise will skip the date. So the result will look like Unexcused absence Unexcused Tardy 1/20/2006 1/23/2006 5/20/2006 Thu sI will have a list of all dates that have the each category in the fourth raw and the date in the first raw is <365 days from today. In additions as date changes the list will drop the date as it will be 365 days from the current date. I hope this make sense. Thanks Here it is. One day square and first week of January. Teh cells starts at A10 and ends at Aw268 1/03/06 TPU 8 Occ Unexcused Absence (Whole) January SUN MON TUE WED THU FRI SAT 1 2 01/03/06 4 5 6 HOL 8 TPU 8 Occ Unexcused Absence (Whole) The result should look something like this: Unexcused..(whole) Unexcused ...(Half) Unexcused Tardi 01/03/06(if <365 days from todays date) 02/15/06 03/25/06 01/15/07 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
Cell text based on 4 condition test | Excel Worksheet Functions | |||
Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
How do I create a bulleted list text format inside cell? | Excel Discussion (Misc queries) |