Add incremental number based on conditions in Excel [Solved]

Ask a question Rruwinda - Last answered on Jan 20, 2017 at 12:08 PM by Mazzaropi

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!
plus moins
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
Was this answer helpful?  
Rruwinda- Jan 20, 2017 at 06:27 AM
Hello Mazzaropi,
Thanks a lot! You solved it!
Leave a comment
plus moins
Thanks for the feedback.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!