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