How do I get non-consecutive cell numbers dragged from the same column to the same row?

[wardjdim]

Hi all

I am asking a question I asked as an additional question in a previous thread

If I have a column full of numbers and I just want to add several numbers from this column in another row (so from vertical order to put them horizontally. Let's say, the column I pick for the numbers is column A and the numbers go from cells A1 to A20. I want to pick a number every 5 rows (So, numbers on columns A1, A6, A11 and A16)

How do I make these four numbers appearing on rows B1, C1, D1 and E1 automatically. So, this means not by writing at B1 =A1, at C1, =A6. etc.

In other words, I need the cell number to jump by 5. To read the data 5 cells downwards automatically (meaning, always 5 cells downwards)

Cheers again

 

[wardjdim]

Oh, you re really great

Thanks very much

Ok

Now, I easily managed to do the rest of the columns!!!

 

[Jonmo1]

Glad to help.

Once you see how it works, it's easy to manipulate..