CODEWITHSUNDEEP
arraysif-statementgoogle-sheetssplitgoogle-sheets-formula
J. SungHoon
J. SungHoon

Reputation: 201

How to get a specific number of cells using an array formula in Google Sheets

I want to pre-process my data like the Result section of the attached image before flattening and using it.

I want to write an array formula in the cells marked in blue. How do I get results?

enter image description here

Upvotes: 1

Views: 40

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IF(COLUMN(A2:D5)<=F2:F5; A2:D5; ))

enter image description here

Upvotes: 1

Related Questions