Hi Andy,

Am Wed, 6 Jun 2018 01:55:55 -0700 (PDT) schrieb Andy McNicol:

How it looks...

A B C D E F G H I J K L M..........
1 5 9 7

Using Indirect I get...

A B C D E F G..........
1 5 9 7

Which works as it only gives me the cells I need, however want it as follows;

A
1
5
9
7

in A1:
=INDEX(Sheet1!$1:$1,,ROW()*2-1)
and copy down.


Regards
Claus B.
--
Windows10
Office 2016