G
Guest
Hello All !!
I'll keep it simple but would appreciate help.
Firstly I start with a blank sheet
In column A, I type the numbers 1 through 20, in order for 20 rows,
underneath each other, so that finally A20 = 20. I know I can use auto fill
after typing 1 and 2.
Then in column B I want to copy the A-values but by adding a step. Assume a
step of 3. Then I want;
B1 = cell contents of A1
B2 = cell contents of A4
B3 = cell contents of A7
and so on. I would like to know how to get excel to understand my pattern,
and auto fill it by highlighting.
In my real spreadsheet i have various random sales figures in Column A, and
want to copy every 7th figure into column B.
Help would be appreciated.
Many Thanks
Rajen
I'll keep it simple but would appreciate help.
Firstly I start with a blank sheet
In column A, I type the numbers 1 through 20, in order for 20 rows,
underneath each other, so that finally A20 = 20. I know I can use auto fill
after typing 1 and 2.
Then in column B I want to copy the A-values but by adding a step. Assume a
step of 3. Then I want;
B1 = cell contents of A1
B2 = cell contents of A4
B3 = cell contents of A7
and so on. I would like to know how to get excel to understand my pattern,
and auto fill it by highlighting.
In my real spreadsheet i have various random sales figures in Column A, and
want to copy every 7th figure into column B.
Help would be appreciated.
Many Thanks
Rajen