Hey there, this is my first post here (or anywhere regarding excel help), so I'm curious how good you guys are! Also I hope I'm posting this in the correct forum in the correct way.
I work for a homeless organization where I manage a shared database. When a person goes to a one of the organizations for help, their financial information is recorded into the database. This helps the services providers work together in seeing which programs are helping the most.
What I'm working on now is trying to find how many people have an improved income amount after coming to our organization. I've attached the sheet and will explain it here:
Column A: This represents the individual client
Column B: This is the date the income was recorded
Column C: This is the income Amount
Column E: This represents what organization recorded the income. Our organization is represented by the value "a"
What I need to know is how many people improved their income AFTER coming to OUR organization. So to count the client would need an assessment from organization "a", and then another assessment AFTER that date with a higher income amount. The higher income amount could be recorded from our organization or another one.
Hopefully this all makes sense, but if not let me know and I will try to clarify. Any help is greatly appreciated and going to a good cause! Thanks, Jon
Bookmarks