|
|
#11
06-24-2020, 11:00 AM
|
|||
|
|||
Do you have 85. in A120?
If so, select A121 Paste this formula in the Refers to field in Name Manager: =MID(!A1,1,LEN(!A1)-1) and write previous in the Name field. Close. In cell A121 enter the formula: =previous+1&"." and copy down. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Deleted entire row, but numbering series gone wrong. Help me. | kingston123 | Excel | 16 | 06-25-2020 08:16 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 |
Windows 10 
Office 2016
Threaded Mode