CODEWITHSUNDEEP
excel
user8920020
user8920020

Reputation:

Is there a function in Excel to select every n-th cell in a column?

I have a column of values in Excel, and I want to select only every 4th value, so for example cells A4, A8, A12, A16, etc, is there a formula to do this?

I've tried making a separate column of numbers that have my values, so a column with values 4, 8, 12, 16, etc, but I don't know how to tell Excel that I want the cell in column A with the row number specified in (for example) cell B52.

Upvotes: 0

Views: 1057

Answers (1)

Scott Craner
Scott Craner

Reputation: 152585

Put this in B1:

=INDEX(A:A,ROW(A1)*4)

And copy down.

enter image description here

Once Microsoft releases the new formula to Office 365 we can make it dynamic:

=INDEX(A:A,SEQUENCE(INT(MATCH("zzz",A:A)/4),,4,4))

One would only need to put that in B1 and the rest would get filled in.

enter image description here

Upvotes: 2

Related Questions