Forum Discussion
Auto fill
Want to drag down increment by 10 not 1.
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!
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?