Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use an index number in a search range
The following returns the relative position of an entry in a row of unsorted
data: {=MATCH(TRUE,D!C22:BD22<C22,0)} How can I use the value returned by the above for the beginning position in a search range in row# 22 similar to: =max(the value created by the above formula:k22) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use an index number in a search range
Nick,
With that formula in cell A1: =MAX(INDIRECT(ADDRESS(22,A1+2)&":K22")) You need to add 2 to account for the offset from column A of your search range. HTH, Bernie MS Excel MVP "Nick Krill" wrote in message ... The following returns the relative position of an entry in a row of unsorted data: {=MATCH(TRUE,D!C22:BD22<C22,0)} How can I use the value returned by the above for the beginning position in a search range in row# 22 similar to: =max(the value created by the above formula:k22) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use an index number in a search range
Nick,
I cannot fully understand what you are looking for, but it seems to me you need the OFFSET()function. Use the expression as the 3rd argument. If your problem went down columns instead of across rows you could have also used INDIRECT(). HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a negative number in a range | Excel Worksheet Functions | |||
Assign one number to a number range | New Users to Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
Assign a dollar amount to a corresponding number in a range of num | Excel Discussion (Misc queries) |