Copy Formula Down

[nacskins]

I have searched and i am unable to find an answer, is there a way to copy a formula down a column and have it auto skip every other ref cell. Example below. Thanks

=CONCATENATE(A2, ",")
=CONCATENATE(A4, ",")

 

[Joe4]

What cell exactly are you putting the first formula in?

 

[Joe4]

If the first formula were to go in row 1, then you could use this formula:

=CONCATENATE(INDIRECT("A" & ROW()*2),",")

and copy down for all rows.

If any other row, you will need to add/subtract some value from the row calculation to get it to work.

 

[nacskins]

What cell exactly are you putting the first formula in?

Pro Plus 2016

 

[Joe4]

Pro Plus 2016

That is not a cell address (range).
A cell address is like "B1" or "J10".
I am asking where exactly on your sheet the first formula goes.
The reason for this is my reply makes use of the row number that the formula resides in, so may need to be adjusted based on where you are putting it.

 

[nacskins]

My apologies, i should have provided more info. I am going to be scanning multiple barcodes, in column B i only want to to transfer over what is scanned in Column A, every other line.

 

[Joe4]

You still aren't answering my question.

Please tell me the EXACT cell addresses these first two formulas should be in:
=CONCATENATE(A2, ",") <--what cell address will this formula be in?
=CONCATENATE(A4, ",") <--what cell address will this formula be in?

 

[nacskins]

That is not a cell address (range).
A cell address is like "B1" or "J10".
I am asking where exactly on your sheet the first formula goes.
The reason for this is my reply makes use of the row number that the formula resides in, so may need to be adjusted based on where you are putting it.

lol my apologies, coffee has not kicked in, i read "excel" not "cell", i was wondering what diff that would make.

 

[nacskins]

You still aren't answering my question.

Please tell me the EXACT cell addresses these first two formulas should be in:
=CONCATENATE(A2, ",") <--what cell address will this formula be in?
=CONCATENATE(A4, ",") <--what cell address will this formula be in?

B2, B3, b4, and so on..... each one increasing by 2 digits.

 

[Joe4]

B2, B3, b4, and so on..... each one increasing by 2 digits.

OK, then this version should do it.
Put this in cell B2 and copy down:

=CONCATENATE(INDIRECT("A" & (ROW()-1)*2),",")