Results 1 to 18 of 18

Problems combining IF and MAX to get the right result

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2012
    Location
    Oxford
    MS-Off Ver
    Excel 2010
    Posts
    4

    Problems combining IF and MAX to get the right result

    Hi, I was wondering if anyone could help. Its a tricky question to ask - so I am hoping the answer is more straightforward than the wording of the question! OK Imagine the following table

    Fruit Date Price New Date
    Apple 01/01/00 1
    Apple 02/02/00 2
    Banana 03/03/00 1
    Banana 04/04/00 2
    Pear 05/05/00 1
    Pear 06/06/00 2

    WHat I would like to appear in the New date column is the date that each fruit was at its most expensive, so the table would become:

    Fruit Date Price New Date
    Apple 01/01/00 1 02/02/00
    Apple 02/02/00 2 02/02/00
    Banana 03/03/00 1 04/04/00
    Banana 04/04/00 2 04/04/00
    Pear 05/05/00 1 06/06/00
    Pear 06/06/00 2 06/06/00

    Is there a formula that would provide me with the outcome above.

    Many thanks for your help,

    Paul
    Last edited by Doctorchuckles; 07-31-2012 at 04:27 AM. Reason: Moderator suggestion

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