Hi All,
I have attached an example doc, Im just looking for a formula that will return the latest date based on the case code.
If you need any more information please let me know.
Thanks
Hi All,
I have attached an example doc, Im just looking for a formula that will return the latest date based on the case code.
If you need any more information please let me know.
Thanks
Hi,
B2=SUMPRODUCT(LARGE(($I$2:$I$36=A2)*($J$2:$J$36),1)) and drag down.
Or you can use B2=LARGE(IF(A2=$I$2:$I$36,$J$2:$J$36),1) with ctrl+shift+enter and drag it down.
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
I've tried to avoid an array formula, but if I wouldn't, I would use rather =MAX(IF(A2=$I$2:$I$36,$J$2:$J$36))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks