Forum Discussion
Auto fill
Want to drag down increment by 10 not 1.
As someone that finds relative referencing and fill-down to be horrible practices, I have set out to use Excel 365 to return the results as a single array formula.
= LET(
p, SEQUENCE(8,,0),
v, DROP(WRAPCOLS(bits, 10), -2) * 2^p,
TOCOL(BYCOL(v, LAMBDA(v, SUM(v))))
)
By traditional methods, the key is to build a helper sequence of integers increasing in 10s.
[Note: I have chosen to interpret the formula as conversions from binary to decimal but it may represent something entirely different]
- First, I thought there was a pull-down menu where you could put a number for the step size.
I guess it doesn't exist. But, after thinking about it for a minute, it is easy.
You just drag down 10 and delete 9 above the last one. Over and over again until done. Not a VBA solution but fast and no thinking.
Thanks everybody!Yes, that is how I generated the formula described as 'manual'.
Is the workbook converting binary numbers held as arrays to decimal, or was I reading too much into the powers of 2?
Are you using Excel 365?
