software

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.

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.

--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000

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