Ask Your Question
0

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
2

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.

=COUNTIF($A1:A1;A1)

CountifSample.ods

edit flag offensive delete link more

Comments

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

Stats

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

Seen: 288 times

Last updated: Jul 16 '14