Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirectly us a Named Range
Hey..
I got the name of several named ranges in colum B. I want to calculate the =Min() of those named ranges in Col C. I thought of =MIN(TEXT(B4;0)) or =MIN(indirect(TEXT("'"&B4&"'";0))) but that doesn't seem to work. Any input is very much appreciated. Thy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirectly us a Named Range
Hallo Chris,
Am Thu, 21 Apr 2011 02:24:58 -0700 (PDT) schrieb chg: I got the name of several named ranges in colum B. I want to calculate the =Min() of those named ranges in Col C. I thought of =MIN(TEXT(B4;0)) or =MIN(indirect(TEXT("'"&B4&"'";0))) =MIN(INDIRECT(B4)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirectly us a Named Range
On Apr 21, 1:00*pm, Claus Busch wrote:
Hallo Chris, Am Thu, 21 Apr 2011 02:24:58 -0700 (PDT) schrieb chg: I got the name of several named ranges in colum B. I want to calculate the =Min() of those named ranges in Col C. I thought of =MIN(TEXT(B4;0)) or =MIN(indirect(TEXT("'"&B4&"'";0))) =MIN(INDIRECT(B4)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 =MIN(INDIRECT(B4)) returns an #REF Error |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirectly us a Named Range
Hi Chris,
Am Thu, 21 Apr 2011 05:31:00 -0700 (PDT) schrieb chg: =MIN(INDIRECT(B4)) returns an #REF Error then you have a typo in the name in column B. Have a look: http://www.claus-busch.de/Excel/Name.xls The named ranges are in A, the names in B and the MIN() in C Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirectly us a Named Range
hi,
the named ranges must be in the same workbook that the INDIRECT formula -- isabelle Le 2011-04-21 08:31, chg a écrit : =MIN(INDIRECT(B4)) returns an #REF Error |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refer to a named range indirectly | Excel Worksheet Functions | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) |