Função do Google Sheets

RANK

Returns the rank of a number in a list of numbers.

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

RANK(number, ref, [order])

The RANK function determines the size of a number relative to other values in a list. If multiple values have the same rank, the function assigns the same rank to each, but the presence of these values affects the ranks of subsequent numbers.

Argumentos

numberobrigatórioThe number whose rank you want to find.
refobrigatórioAn array of, or a reference to, a list of numbers.
orderopcionalA number specifying how to rank; 0 or omitted for descending, any non-zero value for ascending.

Exemplos

=RANK(A2, $A$2:$A$6)

Resultado: 1

Ranks the value in A2 against the range A2:A6 in descending order.

Perguntas frequentes

What happens if two numbers are the same?

The RANK function assigns the same rank to both numbers, but it will skip the next rank in the sequence.

Funções relacionadas

LARGE SMALL