UNIQUE

Returns unique values from a range.

Syntax

=UNIQUE(array)

Example

=UNIQUE(D2:D100)

Creates a dynamic list of unique cities.

SEQUENCE

Generates a sequence of numbers automatically.

Syntax

=SEQUENCE(rows,[columns],[start],[step])

Examples

=SEQUENCE(10)

Returns:

1, 2, 3 … 10

=SEQUENCE(5,1,101,1)

Returns:

101, 102, 103, 104, 105

TRANSPOSE

Changes rows into columns or columns into rows.

Example

=TRANSPOSE(A2:D2)

Practice

Create:

  • Unique city list
  • Automatic Order Numbers
  • Transposed monthly sales report
PreviousNext