Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using
=CONCAT(distinct Year, ' |' )
Use the third argument (sort-weight) to sort.
I have tried but get it to order by descending year. Not sure I understand sort-weight.
Try this:
=CONCAT(distinct Year, ' |' ,-Year)
Did sort-weight parameter work with negative values?