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