Dynamically Aligning formulas to consume data in adjacent columns when using dynamic array function

Copper Contributor

Is there a way to dynamically align formulas in a column adjacent to a column using the unique or filter function?





1 Reply




You can try this formula which dynamically returns the unique values from column C.