I have a table like so

Some-Column |
---|

laurel |

hardy |

cheynny |

cherry |

(more stuff) |

My goal is to return an array containing indices of all non-empty cells, in this case:

`{1, 2, 4, 6,...}`

I thought I could simply multiply the result of `not(isblank({<range1>}))`

by `row({<range1>})`

, i.e. `not(isblank(A2:A15))*row(A2:A15)`

In said array, the first result is a numeric index, however every index from 2 to *n* is a boolean.

Result |
---|

2 |

TRUE |

FALSE |

TRUE |

FALSE |

TRUE |

How can I get the 2:*n* elements of the array to convert to numeric indices?

(If curious, I’m trying to return a list of non-empty cells for use in a dropbox menu via Data->Validity. I want it to list all values some user enters in another column. Said column can grow arbitrarily large. First step is doing this!)