Turn this on bu Alt+W+E+F, or the View tab, and Focus Cell. Note that this currently doesn't work with Freeze Rows, but it's handy anyway!
Turn this on bu Alt+W+E+F, or the View tab, and Focus Cell. Note that this currently doesn't work with Freeze Rows, but it's handy anyway!
UNIQUE(
FILTER(A:A,
(A:A<>"")*
(A:A<>0)
)
)
)
UNIQUE(
FILTER(A:A,
(A:A<>"")*
(A:A<>0)
)
)
)