Hi all,
I have a tracking sheet with a series of names in the first column and previous meeting dates on the second column.
The first column contains multiple entries for some names. I want to list a selection of names with the most recent date for that name. I think it will be some variation of INDEX and MATCH and maybe SMALL but I can't figure it out....
Help!
Hello and welcome to the forum.
How will that look? Can you post a (small) sample file with the desired result entered manually?I want to list a selection of names
With this table in columns A and B
and a name in E2, you can use this array formula
Please Login or Register to view this content.
=MAX(IF($A$2:$A$10=E2,$B$2:$B$10))
Confirm with Ctrl-Shift-Enter
Enter more names below E2 and copy the formula down.
this thread could be helpful Find Lagest Value in Second Column
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
WOW! It was that easy!!! Thank you so much teylyn, that has been driving me nuts!
Last edited by Shodaar; 09-30-2011 at 10:15 AM.
Careful with the language.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks