View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deadeye Deadeye is offline
external usenet poster
 
Posts: 1
Default 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!