Create array multiple parts

[Michielb]

Hi,

I want to make an array containing two 'parts'; I would like to obtain the following row of numbers: (2:N-2,N), so if N = 6 the row would be: (2,3,4,6). I found a formula which can make the first part of the row: =ROW(INDIRECT("2:" &N-2)). How can I add the last number of the row?

Thanks in advance!

Michiel

[samba_ravi]

try
=ROW(INDIRECT("2:"&N-1))+(ROW(INDIRECT("2:"&N-1))=N-1)
or
=ROW(INDIRECT("2:"&B1-1))+(ROW(INDIRECT("2:"&B1-1))=B1-1)

[Michielb]

That's it, thanks!