CODEWITHSUNDEEP
excelexcel-formula
blaughli
blaughli

Reputation: 173

How to specify variables in Excel

I want to select every 6th row in the D column. I thought I could do something like

= D(E1 * 6)

where E is a column that just lists integers 1, 2, 3,....
Excel does not accept this syntax. Is there a way to do this?

Upvotes: 0

Views: 119

Answers (1)

Tmdean
Tmdean

Reputation: 9299

You would use the INDIRECT function to build a cell reference out of a string.

=INDIRECT("D" & E1 * 6)

Upvotes: 2

Related Questions