| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use indirect function?
Does anyone know how to use indirect functionj?
=MIN(Sheet2!A1:A500), I would like to add an integer on B colume =Indirect("MIN(Sheet2!A"&1+B1&":A3"), but it returns #REF!. Does anyone have any suggestion how to apply Indirect function to perform above task? Thanks you in advance Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
| consolidate data using 3d function AND indirect | Excel Worksheet Functions | |||
| INDIRECT function inside AND function | Excel Worksheet Functions | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
Threaded Mode
