scan data, find max value of column, return single record on other worksheet

[virtualnoob]

Hello,

I tried searching but I didn't see anything. I'm trying to scan a range of data, locate the maximum date, and return only 1 unique account record on another worksheet tab. See attached. I would like a button I can click to do this.

Thanks,
VB

[JieJenn]

Please see attached for the solution

[virtualnoob]

Here's the file.

[virtualnoob]

if anyone can help and teach me how to do this, ill paypal you $

edit: and sorry, the final output on the second tab should have B12 instead of the **** purchase

[JieJenn]

Now where is my money?

Please Login or Register  to view this content.

[virtualnoob]

Sweet. Thank you! Okay let me check it at work tomorrow - I'll let you know how it goes.