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 test( unexcused absence, unexcused tardy etc) 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. 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 day sfrom 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 |
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) |