Forum Discussion
John_Maron
May 12, 2023Copper Contributor
Excel dunce! Please help! Don't even know what I'm trying to do is called!
I have a very basic understanding of Excel and need an answer to a question in the clearest terms possible. Step-by-step if possible. Or at least direction in what the function I am trying to accompl...
Lorenzo
May 12, 2023Silver Contributor
Alternative if you run Excel 2021 or 365:
With data in A1:B8 as above:
=INDEX(B1:B8, SEQUENCE(ROWS(B1:B8)/4, 4))