| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MIN across worksheets, with INDIRECT
I don't think I am omitting any quotes or &s, but this doesn't seem to work.
Am I not passing a valid range to the MIN function? =MIN(INDIRECT("Rater1:Rater4!"&B3)) Is there another way to type it, or do I need a more creative function? TIA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN across worksheets, with INDIRECT
Try
=MIN(Rater1:Rater4!&B3)) "andy62" wrote: I don't think I am omitting any quotes or &s, but this doesn't seem to work. Am I not passing a valid range to the MIN function? =MIN(INDIRECT("Rater1:Rater4!"&B3)) Is there another way to type it, or do I need a more creative function? TIA |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN across worksheets, with INDIRECT
I don't think that works without using INDIRECT.
"Sheeloo" wrote: Try =MIN(Rater1:Rater4!&B3)) "andy62" wrote: I don't think I am omitting any quotes or &s, but this doesn't seem to work. Am I not passing a valid range to the MIN function? =MIN(INDIRECT("Rater1:Rater4!"&B3)) Is there another way to type it, or do I need a more creative function? TIA |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN across worksheets, with INDIRECT
Cut and paste error... I tested with Sheet1,..
Try using =MIN(Rater1:Rater4!B3) assuming you want to find the MIN in Cell 3 across four sheets... "andy62" wrote: I don't think that works without using INDIRECT. "Sheeloo" wrote: Try =MIN(Rater1:Rater4!&B3)) "andy62" wrote: I don't think I am omitting any quotes or &s, but this doesn't seem to work. Am I not passing a valid range to the MIN function? =MIN(INDIRECT("Rater1:Rater4!"&B3)) Is there another way to type it, or do I need a more creative function? TIA |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN across worksheets, with INDIRECT
Why don't you try it?
-- David Biddulph "andy62" wrote in message ... I don't think that works without using INDIRECT. "Sheeloo" wrote: Try =MIN(Rater1:Rater4!&B3)) "andy62" wrote: I don't think I am omitting any quotes or &s, but this doesn't seem to work. Am I not passing a valid range to the MIN function? =MIN(INDIRECT("Rater1:Rater4!"&B3)) Is there another way to type it, or do I need a more creative function? TIA |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MIN across worksheets, with INDIRECT
Sorry. I had removed the ampersand.
-- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Why don't you try it? -- David Biddulph "andy62" wrote in message ... I don't think that works without using INDIRECT. "Sheeloo" wrote: Try =MIN(Rater1:Rater4!&B3)) "andy62" wrote: I don't think I am omitting any quotes or &s, but this doesn't seem to work. Am I not passing a valid range to the MIN function? =MIN(INDIRECT("Rater1:Rater4!"&B3)) Is there another way to type it, or do I need a more creative function? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum across worksheets with indirect | Excel Discussion (Misc queries) | |||
| HLookup indirect multiple worksheets | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
