skip every other row when copying formula
I would like to be able to skip every other row when copying a formula. If I
have data in column A for example, and I want to use a simple formula in
column B like "=a1"(in cell b1) and "=a2"(in cell b3) and "=a3"(in cell b5)
and so on. I have tried using the drag and fill but I end up missing cells.
|