CODEWITHSUNDEEP
vbaexcel
onitsuka
onitsuka

Reputation: 3

How to duplicate values from Cell to Cell in Excel?

I need to duplicate the n values from the column A to Column B

Example:

Upvotes: 0

Views: 45

Answers (2)

teylyn
teylyn

Reputation: 35915

Non-volatile option:

=INDEX(A:A,INT((ROW(A1)-1)/2)+1)

(Offset will cause a recalculation of all sheets whenever any cell changes)

Upvotes: 0

Dan Donoghue
Dan Donoghue

Reputation: 6186

You don't need VBA for this.

Divide the row number minus 1 by 2, int it (chop off decimals as opposed to rounding), finally use that as an offset reference.

=OFFSET(A$1,INT((ROW(A1)-1)/2),0)

Drag down

Upvotes: 1

Related Questions