Excel formula to find largest date in the pool and return corresponding value -


i have research question on site , else still can't find right answer.

account     date         status 115937      4/29/2015   begunflow 116448      5/5/2015    enrollmentrejected 116448      4/9/2015    rejected 116523      4/24/2015   enrollmentrejected 120070      4/29/2015   begunflow 120070      5/2/2015    begunflow 1736792     4/29/2015   inactive 1736792     5/1/2015    begunflow 2755700     4/24/2015   enrollmentsubmitted 10418622    4/9/2015    creditfail 25058075    5/5/2015    active 25058075    4/9/2015    pending start 34359030    4/9/2015    pending start 34362064    4/9/2015    pending start 161020809   4/9/2015    creditfail 161020809   4/9/2015    creditfail 161020809   4/10/2015   preenrollmentcancel 405423048   5/9/2015    creditfail 405423048   4/9/2015    creditfail 415096105   4/9/2015    waiting termination 651119087   4/9/2015    active 858051162   4/9/2015    active 949429029   4/9/2015    active 949429029   4/10/2015   rejected 

this data sample of have been struggling do. want able match account column recent date in date column , return corresponding status column.

this formula have tried

=vlookup(max(if($a:$a=e1,$b:$b)),$b$1:$c$24,2,0) 

the problem formula convert date number. have large rows.

the problem not converting date number. problem comes converting output of array formula input.

it work if separate max/if vlookup. output of max you're looking 1 cell, , use cell input vlookup.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -