Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a number from a different column in a formula
I have 2 sets of numbers in 2 columns A and B example:
1 5 2 8 3 36 4 52 5 10 =MAX(B1:B5) How do I get 3 from column A as my answer from using MAX(B1:B5)? Do I need index, offset, match? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a number from a different column in a formula
=INDEX(J:J,MATCH(MAX(K1:K5),K:K)-1)
-- Don Guillett Microsoft MVP Excel SalesAid Software "rhhince" wrote in message ... I have 2 sets of numbers in 2 columns A and B example: 1 5 2 8 3 36 4 52 5 10 =MAX(B1:B5) How do I get 3 from column A as my answer from using MAX(B1:B5)? Do I need index, offset, match? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a number from a different column in a formula
Hi,
You could use =LOOKUP(MAX(B1:B5,4)-1,B1:B5,A1:A5) -- Thanks, Shane Devenshire "rhhince" wrote: I have 2 sets of numbers in 2 columns A and B example: 1 5 2 8 3 36 4 52 5 10 =MAX(B1:B5) How do I get 3 from column A as my answer from using MAX(B1:B5)? Do I need index, offset, match? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Increasing a Cell Reference by a Given Number | Excel Worksheet Functions | |||
Need to indirectly reference columns 26 using A1 notation based on numeric column number- how to? | Excel Worksheet Functions | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
return the column reference number of a function result | Excel Discussion (Misc queries) |