Introducing List X: First and Last (extension/addin)

[davidjayjackson]

Grab Extension here:

List X: First and Last » Libreoffice Extensions

1. The LIST function
   =LIST(range; count; include_header)

include_header is optional (default 0). Set it to 1 to always return the range’s first row as a header row; count then selects from the data rows below it. (TRUE()/FALSE() work too, but 1/0 are simpler.)

Select	Formula (Ctrl+Shift+Enter)	Returns
a 5×3 block	=LIST(A1:C100; 5)	first 5 rows
a 5×3 block	=LIST(A1:C100; -5)	last 5 rows
a 6×3 block	=LIST(A1:C100; -5; 1)	header row + last 5 data rows

Remember the output block must include room for the header row when include_header is 1 (e.g. select 6 rows for a header + 5 data rows).

LIST appears in the Function Wizard under the Add-In category.

[karolus]

use take instead

[Villeroy]

or the traditional OFFSET.

[davidjayjackson]

So, did we copy Excel’s Take function or did they copy ours?
I was gong to create two function head and tail after the Unix/Linux functions

[Wanderer]

@davidjayjackson

did we copy Excel’s Take function

Just read the linked help:

The name space is COM.MICROSOFT.TAKE

Having the functions available is necessary to import xlsx correctly.