Better Way to Write This?

M

Michael

Hi everyone,

Is there a better way to write:

=MIN(ModelOBJ!J4:J33)+MIN(ModelOBJ!J34:J63)+MIN(ModelOBJ!J64:J93)+MIN(ModelOBJ!J94:J123)

A compacted form would be appreciated indeed.

Regards,
Mike
 
S

Stephen Bullen

Hi Michael,
Is there a better way to write:

=MIN(ModelOBJ!J4:J33)+MIN(ModelOBJ!J34:J63)+MIN(ModelOBJ!J64:J93)+MIN(ModelOBJ!J94:J123)

A compacted form would be appreciated indeed.
Click to expand...

Not really. Anything more compact would also be much more complicated

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
 
A

Alan Beban

Michael said:
Hi everyone,

Is there a better way to write:

=MIN(ModelOBJ!J4:J33)+MIN(ModelOBJ!J34:J63)+MIN(ModelOBJ!J64:J93)+MIN(ModelOBJ!J94:J123)

A compacted form would be appreciated indeed.

Regards,
Mike
Click to expand...
Give the 4-area range a name; e.g., dataRange. Then =MIN(dataRange)

Alan Beban
 
Top