#1
|
|||
|
|||
=if(series
Hello everybody
There is a formula to automatically generate ascending numbers based on the neighboring cell? Tanks in advance! example in image below: |
#2
|
|||
|
|||
Its much easier if you add a workbook rather than a screen dump.
Try =COUNTIFS($A$1:A1,A1) Note the locked first A1 then the unlocked second A1. That gives you an expanding range Last edited by Purfleet; 09-24-2020 at 07:21 AM. Reason: typo |
#3
|
|||
|
|||
thanks for the reply, it works
one more question on the same example, can the numbers be repeated according to the cells in column A? AAA 1 AAA 1 AAA 1 BBB 2 BBB 2 CCC 3 CCC 3 CCC 3 |
#4
|
|||
|
|||
Try =IF(A1=A2,C1,C1+1)
|
#5
|
|||
|
|||
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to add dot after numbering series? | kingston123 | Excel | 44 | 06-25-2020 03:59 AM |
Set up Series of events | GreenBoy | Outlook | 1 | 07-09-2018 04:43 PM |
Series numbering | ericjowens | Excel | 2 | 09-03-2015 11:20 AM |
Fill Series | alamorchgirl | Excel | 1 | 08-15-2011 10:05 AM |
Data Series | Zach | Excel | 1 | 11-05-2010 02:45 PM |