Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Trying this again, with correction and clarification:
In the formula below, "$B$3" is a reference to the current worksheet which contains a whole number to be used as a row reference on other worksheets. This formula works when I pass a single-worksheet range to MIN, but not when I pass a multi-sheet reference: =MIN(INDIRECT("Rater1:Rater4!C"&$B$3)) Is there another way to type it, or do I need a more creative function? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MIN across worksheets, with INDIRECT | Excel Discussion (Misc queries) | |||
Sum across worksheets with indirect | Excel Discussion (Misc queries) | |||
Use of Indirect on two worksheets | Excel Worksheet Functions | |||
INDIRECT.EXT problem with missing worksheets | Excel Worksheet Functions | |||
INDIRECT(ADDRESS... Across worksheets | Excel Worksheet Functions |