+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Sharon
    Guest

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

    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.

  2. #2
    Ronald Dodge
    Guest

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

    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

    "Sharon" <[email protected]> wrote in message
    news:[email protected]...
    > 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.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1