Results 1 to 3 of 3

can I look up the maximum value in 2 columns?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-30-2021
    Location
    Mount Gambier, Australia
    MS-Off Ver
    Microsoft Office Home and Student 2019
    Posts
    117

    can I look up the maximum value in 2 columns?

    Can I look up the maximum value in two columns?

    Cell I3 to I5 have basically this code
    =MAX(D14:D108)
    is the code I used but I had to split the table so now I need it to also show the max value in column K14:K108.

    Cells J3 to J5 look up those values and return the date in column A
    =INDEX($C$14:$C$1009,MATCH($I$3,$D$14:$D$1009,0))
    currently looks up D but I need it to look up column K as well (in this formula)
    Attached Files Attached Files
    Last edited by wildecoyote1966; 02-16-2022 at 02:01 AM. Reason: error

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] maximum of cells containing same value in two other columns
    By cdad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2018, 09:08 PM
  2. [SOLVED] Maximum consecutive columns with value equal or above 2
    By Teddy Tash in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-24-2016, 02:09 PM
  3. Maximum Number of Columns
    By martin.j.h in forum Excel General
    Replies: 6
    Last Post: 11-26-2013, 11:44 AM
  4. Maximum width of several columns
    By SteveX in forum Excel General
    Replies: 2
    Last Post: 06-06-2008, 11:27 PM
  5. [SOLVED] auto open all columns to their maximum
    By Paul in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 12:05 PM
  6. [SOLVED] Is there a maximum number of non-contiguous columns that can be h.
    By Harold in forum Excel General
    Replies: 6
    Last Post: 03-01-2005, 06:06 PM
  7. [SOLVED] what is the maximum columns I can have on an excel workbook
    By Zee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2005, 05: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