Spreadsheet: 827079d1682467021-repeat-certain-numbers-2-times-and-sort-everything-ascending-repeat-certain-numbers-2-times-and-sort-everything-ascending
Sheet: Blad1

 | THESE NUMBERS ONLY REPEAT 2 TIMES IF 1 DECIMAL IS USED. I WANT THE NUMBERS TO REPEAT 2 TIMES DESPITE NUMBER OF DECIMALS |  | THESE NUMBERS ONLY REPEAT 2 TIMES IF 1 DECIMAL IS USED. I WANT THE NUMBERS TO REPEAT 2 TIMES DESPITE NUMBER OF DECIMALS |  | THESE NUMBERS ONLY REPEAT 2 TIMES IF 1 DECIMAL IS USED. I WANT THE NUMBERS TO REPEAT 2 TIMES DESPITE NUMBER OF DECIMALS |  | ONLY THE FIRST CELL H4 IS SHOWING UP IN THE LIST A16 TO A1002. I WANT THESE NUMBERS TO REPEAT IN THE ASCENDING ORDER LIST A16 TO 1002 EVEN IF THEY ARE NOT IN ASCENDING ORDER IN ELL H4 TO H12
 | Dataset 1 (Ascending order) |  | Dataset 2 (Ascending order) |  | Dataset 3 (Ascending order) |  | Dataset 4 (Random depths and NOT ASCENDING ORDER)
Thickness of each layer | Depth [m] |  | Depth [m] |  | Depth [m] |  | Depth [m]
3 |  |  | 4.7 |  | 0.5 |  | 1.33 | THIS NUMBER SHOWS UP 1 TIME BUT DOES NOT REPEAT 2 TIMES
4.5 |  |  |  |  | 2.7 |  | 2.57 | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
0.5 |  |  |  |  |  |  | 0.33 | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
 |  |  |  |  |  |  |  | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
 |  |  |  |  |  |  |  | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
 |  |  |  |  |  |  |  | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
 |  |  |  |  |  |  |  | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
 |  |  |  |  |  |  |  | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
INCREMENT |  |  |  |  |  |  |  | I WANT THIS NUMBERS TO REPEAT 2 TIMES. THE CELL TO THE LEFT COULD BE LEFT EMPTY
0.1 | THIS CAN BE THE NORMAL INCREMENT USED IN A16 TO A1002. IF FOR EXAMPLE 2 DECIMALS ARE USED OR MORE THEN THE INCREMENT SHOULD BE TO THE CLOSEST VALUE IN THE ASCENDING ORDER WITH REGARDS TO THE INCREMENT IN A13, SEE EXAMPLE IN CELL A16 TO A1002 OF HOW I WANT EVERYTHING TO BE SORTED
ASCENDING ORDER BELOW SHOULD BE WITH A NORMAL INCREMENT I WANT TO SET IN CELL A13 |  |  | HOW I WANT IT TO SORT IN ASCENDING ORDER WITH ALL THE ABOVE NUMBERS IN EACH COLOURED FIELD
Depth [m] |  |  | Depth [m]
0 |  |  | 0
 |  |  | 0.1 |  | =IF(ROWS(B$16:B17)>SUM($C$16:$C$102),"",INDEX($A$16:$A$102,MATCH(ROWS(B$16:B17)-1,MMULT(--(ROW($A$16:$A$102)>TRANSPOSE(ROW($A$16:$A$102))),$C$16:$C$102))))
 |  |  | 0.2
 |  |  | 0.3
 |  |  | 0.33
 |  |  | 0.33
 |  |  | 0.4
 |  |  | 0.5
 |  |  | 0.5
 |  |  | 0.6
 |  |  | 0.7
 |  |  | 0.8
 |  |  | 0.9
 |  |  | 1
 |  |  | 1.1
 |  |  | 1.2 |  | I WANT THIS NUMBER REPEATED 2 TIMES
 |  |  | 1.3
 |  |  | 1.33
 |  |  | 1.33
 |  |  | 1.4
 |  |  | 1.5
 |  |  | 1.6
 |  |  | 1.7
 |  |  | 1.8
 |  |  | 1.9
 |  |  | 2
 |  |  | 2.1
 |  |  | 2.2
 |  |  | 2.3
 |  |  | 2.4
 |  |  | 2.5
 |  |  | 2.57
 |  |  | 2.57
 |  |  | 2.6
 |  |  | 2.7
 |  |  | 2.7
 |  |  | 2.8
 |  |  | 2.9
 |  |  | 3
 |  |  | 3
 |  |  | 3.1
 |  |  | 3.2
 |  |  | 3.3
 |  |  | 3.4
 |  |  | 3.5
 |  |  | 3.6
 |  |  | 3.7
 |  |  | 3.8
 |  |  | 3.9
 |  |  | 4
 |  |  | 4.1
 |  |  | 4.2
 |  |  | 4.3
 |  |  | 4.4
 |  |  | 4.5
 |  |  | 4.6
 |  |  | 4.7
 |  |  | 4.7
 |  |  | 4.8
 |  |  | 4.9
 |  |  | 5
 |  |  | 5.1
 |  |  | 5.2
 |  |  | 5.3
 |  |  | 5.4
 |  |  | 5.5
 |  |  | 5.6
 |  |  | 5.7
 |  |  | 5.8
 |  |  | 5.9
 |  |  | 6
 |  |  | 6.1
 |  |  | 6.2
 |  |  | 6.3
 |  |  | 6.4
 |  |  | 6.5
 |  |  | 6.6
 |  |  | 6.7
 |  |  | 6.8
 |  |  | 6.9
 |  |  | 7
 |  |  | 7.1
 |  |  | 7.2
 |  |  | 7.3
 |  |  | 7.4
 |  |  | 7.5
 |  |  | 7.5 |  | SHOULD BE REPEATED TWICE
 |  |  | 7.6
 |  |  | 7.7
 |  |  | 7.8
 |  |  | 7.9
 |  |  | 8
 |  |  | 8