Forum Discussion
Solved
Help on a UNIQUE formula
Hi I have the following list of year: 2022 2023 2023 2025 2025 2026 2027 2028 from A1:K1 I wish to find the single values and put the following formula in B1=SINGLE(A1:K1) but got the sames val...
UNIQUE works down the array to generate a distinct set of rows. To do the reverse and work from left to right across an array (here just a single row) you need to add a further parameter
= UNIQUE(year,1)
where 'year' is a defined name that refers to A1:K1.
I believe you want the unique function:
=Unique(A1:K1)
=Unique(A1:K1)