+ Reply to Thread
Results 1 to 4 of 4

Help regarding index function and max function

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Help regarding index function and max function

    Hi all,

    so im currently trying to solve a porblem. I wrote a function that shows me the maximum in regards to a set category. For example, in the attached file, in row 2 the formula [F2] looks up the maximum value in the row (which is 74 [C2]) and then prints the catagory [C1]. In this case: "afternoon". However I am only intrested in true maxima. Meaning if there are equal values like in row 6, I dont want the formula to print "morning" [F6] but rather leave the field empty or print something diffrent like "0" or "both".

    Does anyone know how to achieve this?

    Kind regards
    MrMoody
    Attached Files Attached Files
    Last edited by MrMoody; 09-30-2020 at 07:01 AM.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Help regarding index function and max function

    Could be like this:

    Into F2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    that's array formula so you have to accept it with Ctrl+Shift+Enter not just Enter as usual.
    then
    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    1
    morning noon afternoon evening night Main
    2
    49
    55
    74
    39
    0
    afternoon
    3
    0
    0
    1
    0
    evening
    4
    2
    2
    2
    1
    1
    3 the same
    5
    2
    7
    13
    7
    0
    afternoon
    6
    1
    0
    0
    1
    0
    2 the same
    7
    4
    16
    34
    22
    0
    afternoon
    Sheet: Sheet1
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    08-23-2018
    Location
    Germany
    MS-Off Ver
    365
    Posts
    32

    Re: Help regarding index function and max function

    Amazing!!! Thank you for your help!!!

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Help regarding index function and max function

    Happy to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Nesting and Index and Match function inside an IF function
    By breckleeb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-29-2016, 11:06 AM
  2. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  3. Replies: 1
    Last Post: 06-02-2015, 01:38 AM
  4. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  5. [SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-11-2012, 06:22 PM
  6. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  7. Emulate Index/Match combo function w/ VBA custom function
    By Spencer Hutton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2005, 01:06 PM

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