Pasting specific number in a column- please help me do my homework
 

Hello,

I have a large amount of data in a single column. What i want to do is
select every 24th number and paste it into a new column so there are no gaps.
Is there a way of doing this? I really don't feel like doing it manually over
1000 times!

I've done a simplefied example below using every 3rd number to show what i
want to acheive

1 3
2 6
3 9
4 12
5
6
9
10
11
12

Sorry if this is a stupid question, but i'm a bit of a novice on excel and i
haven't got a clue how to do this!

Thanks in advance!

Pasting specific number in a column- please help me do my homework
 

Deadeye,

Data in Column A.The trick now is to understand how this works instead of
just using it as a homework answer

=OFFSET($A$1,(ROW()-1)*24,0)

In B1 and copy down

Mike

"Deadeye" wrote:

Hello,

I have a large amount of data in a single column. What i want to do is
select every 24th number and paste it into a new column so there are no gaps.
Is there a way of doing this? I really don't feel like doing it manually over
1000 times!

I've done a simplefied example below using every 3rd number to show what i
want to acheive

1 3
2 6
3 9
4 12
5
6
9
10
11
12

Sorry if this is a stupid question, but i'm a bit of a novice on excel and i
haven't got a clue how to do this!

Thanks in advance!

Pasting specific number in a column- please help me do my homework
 

In B1 enter:

=INDIRECT("A" & 24*ROW()) and copy down
--
Gary''s Student - gsnu200771


"Deadeye" wrote:

Hello,

I have a large amount of data in a single column. What i want to do is
select every 24th number and paste it into a new column so there are no gaps.
Is there a way of doing this? I really don't feel like doing it manually over
1000 times!

I've done a simplefied example below using every 3rd number to show what i
want to acheive

1 3
2 6
3 9
4 12
5
6
9
10
11
12

Sorry if this is a stupid question, but i'm a bit of a novice on excel and i
haven't got a clue how to do this!

Thanks in advance!