Oct 27 2023 12:19 PM
To fill cells in Excel with an increment of 10 instead of 1, you can use the AutoFill feature with a custom fill series. Here's how you can do it:
Release the mouse button, and Excel will fill the selected cells with values incremented by 10.
For example, if A1 had the value 10, and you drag the fill handle down, you'll get a sequence in cells A2, A3, A4, and so on, with increments of 10 (20, 30, 40, and so on).
This method allows you to easily create a series of values with a specified increment. The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Oct 27 2023 01:07 PM
in one cell
=pattern!B2+pattern!B3*2+pattern!B4*4+pattern!B5*8+pattern!B6*16+pattern!B7*32+pattern!B8*64+pattern!B9*128
WANT next row (one down)
=pattern!B12+pattern!B13*2+pattern!B14*4+pattern!B15*8+pattern!B16*16+pattern!B17*32+pattern!B18*64+pattern!B19*128
NOT
=pattern!B3+pattern!B4*2+pattern!B5*4+pattern!B6*8+pattern!B7*16+pattern!B8*32+pattern!B9*64+pattern!B10*128
Oct 27 2023 02:03 PM - edited Oct 27 2023 02:19 PM
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]
Oct 27 2023 08:27 PM
Oct 27 2023 11:02 PM
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?