Quick key for copying cell to the right?

Can you post a small sample of your data...along with the results you want to see?

Say you want to have every other cell in column C have the value from column B.

In C1 : =If(IsEven(Row(),B1,"")
and copy it down as many rows as there are data

This formula gives an error. I have attached a sample. Basically I want this
Value 1 Value 2 What I want
a b a
a b b
a b a
a b b
a b a
a b b
a b a

Hi Onestopfanshop;

Did the formula actually produce an error? "#Error#"
Or is just not giving the results you want? I didn't know that you also wanted column A on every other row.

Please Login or Register  to view this content.

and copy down the column

given op is starting in row 2 =If(IsEven(Row()),a2,b2)