Hi All
I would like to create a formula that generates a number based on date and other cells which will be composed of 3 parts :
1901- 50158-0001
So the first part is the year and month : like if it's 2019 january, it will make 1901, the second is a combination of values from multiple cells , like if cell A11 = 50, A12 = 15 and A13 = 8 , then the last part is only progressive number . this code will be create on a column ,so the successive cell in the column will be a progression of the previous therefore that 0001 will change to 0002 and so on. At the moment no idea comes to my mind how to do this.
I would like to create a formula that generates a number based on date and other cells which will be composed of 3 parts :
1901- 50158-0001
So the first part is the year and month : like if it's 2019 january, it will make 1901, the second is a combination of values from multiple cells , like if cell A11 = 50, A12 = 15 and A13 = 8 , then the last part is only progressive number . this code will be create on a column ,so the successive cell in the column will be a progression of the previous therefore that 0001 will change to 0002 and so on. At the moment no idea comes to my mind how to do this.