Smoerble
asked on
Get latest entries in list?
I have a list:
Date - Name - Comment
1.2.2012 - Anna - Calls someone
2.2.2012 - Anna - gets a call
3.2.2012 - Anna - Is on vacation
1.2.2012 - Cindy - Calls Anna
3.2.2012 - Cindy - Dates John
1.2.2012 - Dirk - Is alone at home
I want to display for each person the latest activity, so I need a result like this:
3.2.2012 - Anna - Is on vacation
3.2.2012 - Cindy - Dates John
1.2.2012 - Dirk - Is alone at home
Can you do this with regular formula? Anyone has an idea how to do it please?
Date - Name - Comment
1.2.2012 - Anna - Calls someone
2.2.2012 - Anna - gets a call
3.2.2012 - Anna - Is on vacation
1.2.2012 - Cindy - Calls Anna
3.2.2012 - Cindy - Dates John
1.2.2012 - Dirk - Is alone at home
I want to display for each person the latest activity, so I need a result like this:
3.2.2012 - Anna - Is on vacation
3.2.2012 - Cindy - Dates John
1.2.2012 - Dirk - Is alone at home
Can you do this with regular formula? Anyone has an idea how to do it please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
List-Test.xlsx