Hi,

The first question:
Is there some way to replace a big formula to small?

I have, for example, =AVERAGE(MAX(MIN(CONCATENATE("SH1!",N5))))
and I want to use it many times:
=NEW_NAME("SH1!",N5)
=NEW_NAME("SH1!",K9)
and so on

Does Excel have some options to make this, without vba of course.

The second question:
Is there a way to trigger the formula at particular time without using vba.

The third question:
How can I re-calculate the formula when something is changing in a given range, for example:
I have =CONCATENATE("SH1!",H7), and I want re-calculate it when something is changing in J8:J88.
Is it possible?