Prev: [discuss] [calc]how to select a row (or column) from a range
Next: [discuss] Community Council Elections 2010-06: Phase "Voting by theConstituency" Starts
From: Niklas Nebel on 24 Jun 2010 13:44
On 06/24/10 19:14, Larry Evans wrote:
> Name, example_table, is defined as @Sheet1.$A1:$H13.
> I want to match("col2";A1:H1,;0) but use
> some function on example_table instead of hardcoding
> A1:H1. How do I do that? I hoped there would be
> some function like select_row(example_table,1), but
> I couldn't find anything like that in the available
> functions.

You can use INDEX(example_table;1). No column index means all columns
from the range.

Niklas

---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org
For additional commands, e-mail: discuss-help(a)openoffice.org

 | 
Pages: 1
Prev: [discuss] [calc]how to select a row (or column) from a range
Next: [discuss] Community Council Elections 2010-06: Phase "Voting by theConstituency" Starts