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

Rruwinda - Jan 19, 2017 at 06:31 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- Jan 20, 2017 at 12:08 PM
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!
See more 

3 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Updated by Mazzaropi on 19/01/17 at 07:36 AM
2
Thank you
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

Thank you, Mazzaropi 2

Something to say? Add comment

CCM has helped 1805 users this month

Hello Mazzaropi,
Thanks a lot! You solved it!
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jan 20, 2017 at 12:08 PM
0
Thank you
Thanks for the feedback.

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