Avatar of Smoerble
Smoerble
Flag for Germany 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?
E-CommerceMicrosoft Excel

Avatar of undefined
Last Comment
dlmille

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
dlmille

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Smoerble

ASKER
Attached an example file. Hope, this makes it more clear. The result in the list is NOT correct.
List-Test.xlsx
SOLUTION
dlmille

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61