Post #2325051
2026-04-28 11:53 UTC
am I just really dumb or is there not a great way to write a spreadsheet formula that selects all non-empty cells in a column except the header
Replies (2)
-
@pickled_pineapple@c.im 2026-04-28 11:55
@samhenrigold@hachyderm.io Does the dot operator get you close? https://www.youtube.com/watch?v=euzheB5BfTQ
-
@yesh@tech.lgbt 2026-04-28 15:11
@samhenrigold@hachyderm.io a slow formula, so not for repeated use above several thousands of rows, but =drop(filter(A:A,A:A<>""),1) outputs an array of non-empty cells in column A, less the first row.