+ Reply to Thread
Results 1 to 2 of 2

IF and MAX in one formula but two criterias

Hybrid View

  1. #1
    Registered User
    Join Date
    09-04-2006
    Posts
    1

    IF and MAX in one formula but two criterias

    Column A is listed week 1 to 4 for a month. Column B has the dates for the week. Column C has got various values ranging from 1 to 50.

    Now the question. Using Column A as our first criteria, which day in week 1 is the best days performance for the week (remember you have a few 2006/09/04s).

    The answer must provide the day and the value.

    Anybody who can provide the correct working answer, can go home early.

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    Assuming the maximum is unique! the values are positive. Extend the ranges as appropriate

    Value entered in H6
    =MAX(IF(A2:A12=1,C2:C12,0))

    Date
    =OFFSET(b1,MATCH("1"&h6,A2:A12&C2:C12,0),0)

    Both the formulas are arrays and entered with shft ctrl enter

    Regards

    Dav

+ 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