Below is a possible solution to the challenge Challenge 52 – Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5…
Put following formula and drag down
=FLOOR((1+((1+8*ROWS($1:1)-1)^0.5))/2,1)
Below is a possible solution to the challenge Challenge 52 – Generate the Sequence 1,2,2,3,3,3,4,4,4,4,5,5,5,5,5…
Put following formula and drag down
=FLOOR((1+((1+8*ROWS($1:1)-1)^0.5))/2,1)