Lookup & Reference
★ 30 · ◉ 21 · All versions
=ROW()
Returns the row number of a reference.
=ROW([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Numbering & Sample Data
11 functions for this use case · out of 12 defined
Lookup & Reference
★ 50 · ◉ 20 · All versions
=COLUMN()
Syntax: COLUMN([reference])
=COLUMN([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Logical
★ 12 · ◉ 13 · Excel 365
=MAKEARRAY()
Returns a calculated array of a specified row and column size, by applying a LAMBDA function
=MAKEARRAY(rows, cols, lambda(row, col))
Numbering & Sample Data
Advanced Formulas
Lookup & Reference
★ 35 · ◉ 12 · All versions
=COLUMNS()
Returns the number of columns in an array or reference.
=COLUMNS(array)
Numbering & Sample Data
Worksheet Info & Navigation
Lookup & Reference
★ 40 · ◉ 12 · All versions
=ROWS()
Returns the number of rows in a reference or array.
=ROWS(array)
Numbering & Sample Data
Worksheet Info & Navigation
Math & Trig
★ 80 · ◉ 12 · All versions
=SUBTOTAL()
Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
=SUBTOTAL(function_num,ref1,[ref2],...)
Daily Tasks
Reporting
Math & Trig
★ 30 · ◉ 11 · Excel 2021
=RANDARRAY()
Learn about the RANDARRAY function for creating arrays of random numbers between 0 and 1. RANDARRAY is in a class of functions called dynamic arrays.
=RANDARRAY([rows],[columns],[min],[max],[whole_number])
Numbering & Sample Data
Math & Trig
★ 25 · ◉ 10 · All versions
=RAND()
RAND returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.
=RAND()
Numbering & Sample Data
Statistical
★ 70 · ◉ 9 · All versions
=COUNTA()
The COUNTA function counts the number of cells that are not empty in a range.
=COUNTA(value1, [value2], ...)
Daily Tasks
Reporting
Math & Trig
★ 30 · ◉ 9 · All versions
=RANDBETWEEN()
Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.
=RANDBETWEEN(bottom, top)
Numbering & Sample Data
Math & Trig
★ 55 · ◉ 9 · Excel 2021
=SEQUENCE()
Learn more about the SEQUENCE function, which allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. SEQUENCE is in a class of functions called dynamic arrays.
=SEQUENCE(rows,[columns],[start],[step])
Numbering & Sample Data
Dynamic Ranges & Dashboards