Add incremental number based on conditions in Excel
Solved/Closed
Rruwinda
-
Jan 19, 2017 at 06:31 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jan 20, 2017 at 12:08 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jan 20, 2017 at 12:08 PM
Related:
- Add incremental number based on conditions in Excel
- Pdf and xps add in 2007 - Download - Other
- Number to words in excel - Guide
- How to add @ in laptop - Guide
- Add accent over e - Guide
- How to take screenshot in excel - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Updated by Mazzaropi on 19/01/17 at 07:36 AM
Updated by Mazzaropi on 19/01/17 at 07:36 AM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 20, 2017 at 12:08 PM
Jan 20, 2017 at 12:08 PM
Thanks for the feedback.
I'm glad to be of help.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I'm glad to be of help.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jan 20, 2017 at 06:27 AM
Thanks a lot! You solved it!