numerar a entrada de dados de uma coluna

Question

Tenho uma coluna (coluna A) onde tenho diferentes dados e esses mesmos dados podem-se repetir em diversas linhas, quero que na coluna B seja colocado a numeração de entrada dos diversos numeros e que quando se repetem seja atribuido o mesmo numero pelo qual entrou a primeira vez. e não estou a conseguir por a formula na coluna B.&nbsp;&nbsp;Exemplo:&nbsp;&nbsp;Coluna A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Coluna B&nbsp; &nbsp;1030&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp;2350&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp;1100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp;1030&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp;3584&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;

oliverscheurich · Answer

=SI(CONTAR.SI($A$2:A2;A2)=1;MAX($B$1:B1)+1;INDICE($B$2:B2;COINCIDIR(A2;$A$2:A2;0)))This formula returns the intended result in my sheet.

Forum Discussion

numerar a entrada de dados de uma coluna

1 Reply

Resources