Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 270)

270 Chapter 12 Dictionary of Functions

ROW

The ROW function returns the row number of the specified cell.

ROW([cell])

Â cell: Optional; a reference to a single cell. If not provided, ROW returns the row of the

cell containing the function.

ROWS

The ROWS function counts how many rows are in the specified range of cells.

ROWS(cell-range)

Â cell-range: A reference to a range of cells.

Notes

If you select an entire column for cell-range, Numbers returns the total number of cells

in the column, which changes when you resize the table.

The SEARCH function finds the starting position of one string within another, ignoring

case but allowing wildcards.

SEARCH(search-text, where-to-look, [start])

Â search-text: The string you want to find. You can include an asterisk (*) to match any

number of characters or a question mark (?) to match any single character.

Â where-to-look: The text in which you want to look for the string.

Â start: Optional; a number indicating the position in the text where you want to start

the search. If omitted, the search starts at the beginning of the text.

Examples

ROW(B7) returns 7, the number of row 7.

ROW() returns the absolute row number of the cell containing the function.

Examples

ROWS(A11:D20) returns 10, the number of rows from 11 through 20.

ROWS(D:D) returns the total number of rows in column D.

1 2 ... 265 266 267 268 269 270 271 272 273 274 275 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 270