Hi,

A B C D E F G... AZ
X L M N O P Q...
X
...

here is my question: in col A, i need a formula to automatically display every other cell from row 1

eg, from above, col A would display:
M
O
Q
etc

ideally i would like to have a drop down formula so i don't have to manually enter in col A.

any help much appreciated!

thanks,

helpplease!