Better Way to Write This?

  • Thread starter Thread starter Michael
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding Time down 4
is there a simpler way to do this formula? 5
Running a Macro periodically between Time A and Time B 7
Pretty way to assign a single bit in a FlagsAttribute enum? 4
Change the row number in macro 2
To get row id 1
Looking for help with macros and chart making. 2
looping programing help 1

Back
Top