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!