CODEWITHSUNDEEP
if-statementgoogle-sheetsvlookuparray-formulasnested-if
ranemirusG
ranemirusG

Reputation: 140

array single cell value until next cell with value

How can I take the value from the above cell, and get an array of it until it meets a non-empty cell. All must happen in the same column

Example:

Column A
INPUT (any value)
copy of A1
copy of A1
copy of A1 (the array stops here, because next cell isn't empty)
ANOTHER VALUE

The array should stop without the "overwrite data" error

Upvotes: 1

Views: 132

Answers (1)

player0
player0

Reputation: 1

possible, but you cant jump over existing values so you need a formula in A2, A6, etc...

another solution would be: https://stackoverflow.com/a/69140434/5632629

Upvotes: 1

Related Questions