|
|
#2
03-18-2020, 08:43 AM
|
||||
|
||||
The only way I can think of to do that is to set up the numbers in helping columns elsewhere in the workbook, probably in the same worksheet somewhere to the right.
Like this: In X1 and Y1 put the values 0 and 0. In Y2 put =IF(Y1=39,0,Y1+1). Once you copy this formula down (as far as you like), it causes each value in Y to increment up to 39 and then start over at 0. In X2 put =IF(Y2=0,X1+1,X1). When you copy this formula down, it causes X to stay the same until the value in Y has cycled back around to 0. Now back in column A put =X1&"."&Y1&".00". I haven't tested this code, but I hope it gives you the idea. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I copy a workbook to another workbook and keep the formatting within the new workbook | excelforsue | Excel | 3 | 09-15-2020 03:37 AM |
| Best formula for matching column data from one workbook into another | awpatts | Excel | 1 | 05-10-2017 06:56 AM |
| automatically copy FIRST COLUMN ONLy to all sheets in workbook | nrcahill | Excel | 1 | 03-14-2016 12:26 PM |
| Copy Column setting to other spreadsheets in an excel workbook | officeboy09 | Excel | 5 | 11-05-2013 01:49 AM |
 Spliting column with text and numbers
|
mjosic | Excel | 3 | 04-04-2012 05:56 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode