Thread: Better Way to Write This?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen[_3_] Stephen Bullen[_3_] is offline
external usenet poster
  
Posts: 74
Default Better Way to Write This?
Hi Michael,

Is there a better way to write:

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

A compacted form would be appreciated indeed.

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

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie


Reply With QuoteReply With Quote