Home |
Search |
Today's Posts |
#1
|
|||
|
|||
date function?
i have dates that i'm working with... for example...for one contact person i
might have 3 or 4 different dates... column A column B james 12/24/04 james 1/05/05 james 2/13/05 sue 12/3/04 sue 12/15/04 nick 12/5/04 nick 1//6/05 mary 12/01/04 what i need to do is identify contacts prior to 12/31/04 for those contacts that have only dates 12/31 and before. Some of these contacts have both dates in december '04 and for afterwards in '05. I need only the contacts that have just 12/31 and before dates. But again some of the contacts that i don't need have dates 12/31 and after....these are the ones i want to eliminate. Is there any way that i can do this without separating just 12/31/04 because some of the ones I don't want have the december dates....i'm sorry if i'm not making any sense... so with the above example... out of the above, the only ones i want are "sue & mary" ... any suggestions? |
#2
|
|||
|
|||
On column C type this formula
=SUM(--IF($A$2:$A$9=A2,$B$2:$B$9DATEVALUE("12/31/04"))) Array entered ( ctrl+shift+enter) and copy is down your list Then using filter hide everthing greater than zero In your example it will leave sue and mary "Galway" wrote in message ... i have dates that i'm working with... for example...for one contact person i might have 3 or 4 different dates... column A column B james 12/24/04 james 1/05/05 james 2/13/05 sue 12/3/04 sue 12/15/04 nick 12/5/04 nick 1//6/05 mary 12/01/04 what i need to do is identify contacts prior to 12/31/04 for those contacts that have only dates 12/31 and before. Some of these contacts have both dates in december '04 and for afterwards in '05. I need only the contacts that have just 12/31 and before dates. But again some of the contacts that i don't need have dates 12/31 and after....these are the ones i want to eliminate. Is there any way that i can do this without separating just 12/31/04 because some of the ones I don't want have the december dates....i'm sorry if i'm not making any sense... so with the above example... out of the above, the only ones i want are "sue & mary" ... any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date function question | Excel Discussion (Misc queries) | |||
Is there a function to show future date | Excel Worksheet Functions | |||
Date function | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Formula for date function | Excel Worksheet Functions |