Ask Your Question

How to add increasing counter for cells containing same text? [closed]

asked 2014-07-16 12:53:11 +0200

Pedro gravatar image

updated 2020-08-02 14:40:09 +0200

Alex Kemp gravatar image

If I have a column with a repetitive series of text items, how can I get a counter that shows the number of times that text has already shown up?

I.e. How can I get this?

A   1
A   2
B   1
C   1
A   3
B   2
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-29 21:40:06.802431

1 Answer

Sort by » oldest newest most voted

answered 2014-07-16 13:11:20 +0200

m.a.riosv gravatar image

updated 2014-07-16 13:12:50 +0200

I think a COUNTIF() with a mix of absolute for the beginning of the address and relative for the end, and copying down.



edit flag offensive delete link more


Thank you very much!!! Absolutely perfect and simple! Quoting a wise man: "Make everything as simple as possible, but not simpler." - Albert Einstein

Gracias Miguel Ángel ;)

Pedro gravatar imagePedro ( 2014-07-16 13:20:59 +0200 )edit

Good mention, specially useful with spreadsheet. Não tens de quê Pedro. :)

m.a.riosv gravatar imagem.a.riosv ( 2014-07-16 23:26:14 +0200 )edit

Question Tools

1 follower


Asked: 2014-07-16 12:53:11 +0200

Seen: 666 times

Last updated: Jul 16 '14