"LoveCandle" skrev
i en meddelelse
...

Hi,

What is the benifit of the worksheet function AREAS?

How can we use it with other functions?

Can you please give me an example for that?

Thank you everybody,


--
LoveCandle


Hi

Here's an example of using AREAS

Assume you have a named range (TestBlock) of non
contiguous blocks e.g. A1:A10 + C1:C10 + E1:E10 +
G1:G10 and that this range is expanded every third day.
The name is adjusted to hold the new block as well.


The formula

=INDEX(TestBlock,3,1,AREAS(TestBlock)-1)

will always return the value of the third cell in the last
block but one


--
Best regards
Leo Heuser

Followup to newsgroup only please.