Basic Cell / Formula Copy Using a Step
 

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

Basic Cell / Formula Copy Using a Step
 

One way:

B1: =INDEX(A:A,(ROW()-1)*3+1)

Copy down.

(In article ,
RajenRajput1 wrote:

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

Basic Cell / Formula Copy Using a Step
 

Dude !!

Thanks - it really helps

If any one has any other methods I'm glad to try them - but this is
brilliant. Thanks McGimpsey

Rajen

"JE McGimpsey" wrote:

One way:

B1: =INDEX(A:A,(ROW()-1)*3+1)

Copy down.

(In article ,
RajenRajput1 wrote:

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