I need a little help writing a formula for excel. I need to copy across cells and skip every other cell. For example if I want the value in cells A,C,E,etc. and skip B,D,F, etc. how do I write the formula. I thought it was $ signs but I was wrong. I would copy for single cells however I need to copy across over 200 cells. Thanks in advance.

8/24/2008 1:34:35 PM

not sure about that, but couldn't you just hide the columns you wanted to skip?


there's a macro you could write for this, but I don't know how to do that.

[Edited on August 24, 2008 at 2:09 PM. Reason : .]

8/24/2008 2:08:41 PM

i have an idea, i usually come across this stuff for work

=if(isodd(column(A1)),[formula],"")

or you can change the 'odd' to 'even'



PM me or IM me and we can work through it, i like tryin to figure this stuff out

[Edited on August 24, 2008 at 3:07 PM. Reason : ]

8/24/2008 3:06:58 PM