| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use indirect function?
=MIN(INDIRECT("Sheet2!A"&(1+B1)&":A3"))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Eric" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use indirect function?
Hi,
Try this: =MIN(INDIRECT("Sheet1!A"&1+B1&":A3")) Cheers! Jean-Guy "Eric" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
