Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
0Ok I am trying to do this, I want to use A to show if a donar (Column B) has
been active in the last 30 days. K is how many days since they have donated and L is how many total donations they have given. So I need a forumla that works (mine doesn't seem to) where it will check the date K L number of times and if one of them is less then or equal to 30 then colum A should say True. B = don0r's ID K = days since last donation L = total donations A B ~K L ?? 2 90 4 2 70 4 2 60 4 2 30 4 ?? 31 88 2 34 45 2 So I have colums B-L and set up and I can't figure out how to do column A... any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |