Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect(Address(...
Address(5,$Z$5+60) appears to refer to the cell I want; however, I'm trying
to use the Address function inside a Rank function and have tried it with and without the Indirect function (as shown below) and it doesn't work -- any thoughts? =Rank($BE$5,Indirect(Address(5,$Z$5+60)):Indirect( Address(1000,$Z$5+60))) The range always comes back as 0. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
Array reference using indirect address | Excel Worksheet Functions | |||
=(INDIRECT(ADDRESS(ROW(),#))) with SUMPRODUCT returning #VALUE! | Excel Worksheet Functions | |||
INDIRECT(ADDRESS... Across worksheets | Excel Worksheet Functions | |||
Summing a range using INDIRECT & ADDRESS | Excel Worksheet Functions |