Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

<kidding>As a retired teacher I may know too little about educational choices. But...</kidding>

I would like to also remind you of the fact that the INDEX() function allows for selecting complete rows or columns from a range (whether referenced via direct addressing or via a defined name) by incomplete indexing. See this ornate demo.

(See also 6.14.6 of http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt.)

<kidding>As a retired teacher I may know too little about educational choices. But...</kidding>

I would like to also remind you of the fact that the INDEX() function allows for selecting complete (intersected) rows or columns from a range (whether referenced via direct addressing or via a defined name) by incomplete indexing. See this ornate demo.

(See also 6.14.6 of http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt.)