How to create a number series within an array formula

[Luthius]

How to create a number series within an array formula, I mean, the series starts with 1 and will finish with 8 for example;
{1;2;3;4;5;6;7;8} - It will be the result within my array formula.
In Aij matrix means i=1 to 8 {i+1;i+1;i+1;i+1;i+1;i+1;i+1;i+1}.
I need to retrieve it within an array formula.

How can I do that just using an array formula.

Luthius

 

[GlennUK]

Give examples of your data, and explain what you are trying to achieve.

 

[Luthius]

The interesting here is that I just want get a serie within an array formula. Sometimes we need a series to solve some problems.

 

[ukmikeb]

Hi

Perhaps -

=SUMPRODUCT(--(ROW(INDIRECT(1&":"&8))))

hth

 

[Luthius]

Wow,
that's it. But I have a doubt.
Why the "--" before the LIN() formula?

Thanks for your answer.

Luthius

 

[ukmikeb]

Hi

Habit mainly and the fact that the sheet I was developing at that time had many instances of the "SUMPRODUCT(--(" construct.

Can be used without the -- in this case.

hth

 

[Luthius]

Ok, I tested without "--" and it works too.

Well, almost of all times I saw the "SUMPRODUCT(--" with '--', and I don't know the reason of it.

 

[ukmikeb]

Hi

The double unary "--" is used to coerce True and False to 1 and 0 for the calculations.

Further explanation can be found in the following thread -
http://www.mrexcel.com/forum/showthread.php?t=497594&highlight=double+unary

and links therein especially Aladins post #7.

hth

 

[Luthius]

Thanks for your answer. Now I know the meaning.

Luthius