The Line, Lines, Column, Columns functions

Last update on August 14, 2009 10:52 AM by jak58
Published by netty5

The Line, Lines, Column, Columns functions








You have a table and you have named Office name (for example) with:

INSERT / NAME / DEFINE ..... tick the boxes of the table and the table name Office name (for example)

In this table, you want to know, whatever its location, and even if you move the following:
  • The line number of the 1st row of the table: LINE = (Office name)
  • The No. column of the 1st column: = COLUMN (Office name)
  • Number of rows Office name: LINE = (Office name)
  • Number of columns in the table Office name: = COLUMN (Office name)
Best answers for « The Line, Lines, Column, Columns functions » in :
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ... for...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
They need your help