Forum Discussion
Dynamically Aligning formulas to consume data in adjacent columns when using dynamic array function
Is there a way to dynamically align formulas in a column adjacent to a column using the unique or filter function?
=SORT(UNIQUE(INDIRECT("C3:C"&COUNTA(C:C)+2)))
You can try this formula which dynamically returns the unique values from column C.