How do I list the most recent occrence of a purchase order?

[Guest]

I am working on an Excel spreadsheet that lists information on individuals
based on purchase order number, date of the purchase order number in addtion
to other fields. This report lists activity on a purchase order based on
yyyy/mm/dd format. What I would like to return from this report is the MOST
RECENT activity of the purchase order. For example, activity for PO#12345
for Jane Doe occurred in Jan, Mar, and April. I ONLY want to list the
activity for the same PO on Jane Doe in April.

Thanks.

 

[Ronald Dodge]

You can do this one of 2 ways, via macro or formula. I'm not sure how you
are with macros, but here's the formula method:

Assuming you have all of your data in a table like format, similar to how it
would be stored in a DB environment, you can use formula something like the
follows:

=INDIRECT(ADDRESS(MATCH(MAX($A:$A),$A:$A,0),COLUMN(C:C)))

One potential downfall of this, the MATCH function will only return the
first occurence within the range of that exact value (as specified by the
'0' in the last argument of the function), which then may require to not
only use date, but also time of day as well.