SOLVED

# Formula Problem

Copper Contributor

# Formula Problem

I want to get the same data in two consecutive fields in a column but when I pull the column down it skips the odd fields in the reference.  How do I do this easily?  There are several thousand fields from another tab.

b2 = name J2

B3 = name J2

b4 = name j4

b5 = name j4

2 Replies
best response confirmed by Ron_Hockman1525 (Copper Contributor)
Solution

# Re: Formula Problem

=INDEX(\$J\$2:\$J\$10000,2*QUOTIENT(ROW(J2),2)-1)

Does this return the intended result?

# Re: Formula Problem

Another option is

Note the reference to \$C\$5. This should refer to the cell at the top of the target range. It sets the starting point of your target range.  Also, note the "-1" in the final argument. This should be the number of columns that the source range is away from your target range (-1 is one column to the left). Source and target ranges should start on the same row.

If the source range is on another sheet, you can add the sheet name to the formula as shown here.  In this case, the source range is on "Sheet5" starting at J2 (hence the +7 in the last argument, since J is 7 columns to the right of C).

1 best response

Accepted Solutions
best response confirmed by Ron_Hockman1525 (Copper Contributor)
Solution

# Re: Formula Problem

=INDEX(\$J\$2:\$J\$10000,2*QUOTIENT(ROW(J2),2)-1)

Does this return the intended result?