Select second columns only
 

I want to select every second column between certain rows but I don't want
to do "A4:A20, C4:C20, E4:E20, G4:G20 ..... etc etc".

Is there a more efficient way to show this?

regards

PeterH

What do you want to do with the data.
If you need it to go to someplace else using something like
=indirect("R"&row()-20&"C"&Column()*2-1)
in A24:E40 would group the data in your example.

"My View" wrote:

I want to select every second column between certain rows but I don't want
to do "A4:A20, C4:C20, E4:E20, G4:G20 ..... etc etc".

Is there a more efficient way to show this?

regards

PeterH

You could select that discontiguous range once, then give it a nice range name.
(Insert|Name|define)

Then if you ever need to select it again, you can just:

Edit|goto (or F5 or ctrl-g), type in that name and hit enter

(or even just type the name in the namebox (to the left of the formula bar) and
hit enter.)

But you'd still have to do it at least once.

My View wrote:

I want to select every second column between certain rows but I don't want
to do "A4:A20, C4:C20, E4:E20, G4:G20 ..... etc etc".

Is there a more efficient way to show this?

regards

PeterH

--

Dave Peterson

Thanks for the reply.
I want to impose conditions on those cells by way of a macro. So the
cells will be listed in the macro. They will not be listed in a formula
in the cell(s).
PeterH


bj wrote:
What do you want to do with the data.
If you need it to go to someplace else using something like
=indirect("R"&row()-20&"C"&Column()*2-1)
in A24:E40 would group the data in your example.

"My View" wrote:

I want to select every second column between certain rows but I don't want
to do "A4:A20, C4:C20, E4:E20, G4:G20 ..... etc etc".

Is there a more efficient way to show this?

regards

PeterH