Add incremental number based on conditions in Excel [Solved/Closed]

Report
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
Hello,

I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column based on the first finding duplicates in the first column.

This is what I am looking for:

Column A Column B
Monday 1
Monday 2
Monday 3
Monday 4
Tuesday 1
Tuesday 2
Tuesday 3
Wednesday 1
Wednesday 2
Wednesday 3
Wednesday 4

Looking forward to hear some advices!

4 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
Rruwinda, Good morning.

Try to use:

B1 --> =IF(A1="","",COUNTIF($A$1:A1, $A1))

Copy it down.

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5792 users have said thank you to us this month

Hello Mazzaropi,
Thanks a lot! You solved it!
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
Thanks for the feedback.

I'm glad to be of help.
--
Belo Horizonte, Brasil.
Marcílio Lobão