Ask Your Question

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

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

Pedro 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 +0100

m.a.riosv gravatar image

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

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 +0100 )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 +0100 )edit

Question Tools

1 follower


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

Seen: 288 times

Last updated: Jul 16 '14