Max or min out of two columns
Question: I have two columns and how do I identify the largest number?
Answer: I created two named ranges. List 1: List1 (A2:A10) and List 2: List2 (C2:C10). See picture below.
Formula in B13: =IF(MAX(List1)>MAX(List2),"List 1","List 2")
Formula in B14: =IF(MAX(List1)>MAX(List2),MAX(List1),MAX(List2))
Formula in B15: =IF(MAX(List1)>MAX(List2), MIN(IF(MAX(List1)=List1, ROW(List1);"")), MIN(IF(MAX(List2)=List2, ROW(List2),""))) + Ctrl + Shift + Enter
Download excel sample file for this article.
max-from-two-columns.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
ROW(reference) returns the rownumber of a reference
MIN(number1,[number2])
Returns the smallest number in a set of values. Ignores logical values and text
MAX(number1,[number2],)
Returns the largest value in a set of values. Ignores logical values and text.
Related posts:
- Extract largest values from two columns using array formula in excel
- Filter duplicates from two columns combined and sort from A to Z using array formula in excel
- Comparing two columns and sum unique values using array formula in excel
- Count unique distinct values in three columns combined in excel
- Count matching cell values in two columns in excel
- Count unique distinct values in two columns in excel
- How to filter values between 0.5 and 1.5 from two columns in excel 2007
- Merge two columns into one list in excel
- Create unique list from two columns
- Filter common values from three columns in excel




Leave a Reply