Forum Discussion
samdthompson
Nov 01, 2022Copper Contributor
UNIQUE broken?
Odd behavior with UNIQUE as of today. I can generate a unique list from a vertical range but not from a horizontal one. I can work around with a =TRANSPOSE(UNIQUE(TRANSPOSE(rng))) but it seems super ...
Riny_van_Eekelen
Nov 01, 2022Platinum Contributor
samdthompson Use the second optional argument.
=UNIQUE(rng,TRUE)