MIN IF Function Without Using Array

[MJK]

Is there anyway I can do the below formula without it being an array formula?

Please Login or Register  to view this content.

The reason I ask is because everyday I insert new rows into the 'Data' sheet so I can paste in the previous days data.

However this causes the ranges in my formulas to change, like this:-

Please Login or Register  to view this content.

I would be able to fix this by specifying the ranges as whole columns (e.g. A:A), but I am under the impression that this cannot be done in an array formula. Is this correct?

Any solution on how to get the ranges to stay the same or how to make the formula not an array would be much appreciated.

Thanks

Mark

[arthurbr]

Hi,
you can use Dynamic Ranges. They will adapt automatically to the new range

[MJK]

I think that may do the trick.

Many Thanks!

[IanP]

I know this is an old thread and this is my first post, but I was trying to figure out how to do this without an array as well for excel web app in sharepoint. So this answer didn't work for me either, as there are no named ranges in excel. Anybody have an idea?

[dogberry]

Hi

You would be better off starting a new thread for your question and if you feel this post is relevant link to it


Chris