Skip to content
# EXCEL FUNCTION – ROW

# ROW Function

**Syntax:**

##### Example 1: Exploring ROW function with examples:

**Things to Remember:**

## Recommended Articles

## Similar Posts

### What is VLOOKUP in Excel?

### EXCEL FUNCTION – LEN

### EXCEL FUNCTION – IF

### EXCEL FUNCTION – COUNTIF

### EXCEL FUNCTION – AND, OR, NOT

### EXCEL FUNCTION – RAND

=ROW(reference)

Here we have some examples, where:

- “Column A to B” is a database
- “Column C” shows the sample formula applied,
- “Column D” shows the output of the function and,
- Explanation is provided in Column “E”

We will be using ROW function as follows:

– If Range of cells given in reference argument, then function output will be leftmost row sequence number

– If cell reference is not given in reference argument, then function output will be row sequence number of formula cell

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.

LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.

In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE

Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…

AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”

Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…