Forum Discussion
txrussianguy
Mar 13, 2019Brass Contributor
self-building range of unique values
I need a named range to build itself with unique values, as those values are entered into a separate place. So if I have an 'definitions' tab, where I've set some named ranges, all of which are defi...
JKPieterse
Mar 13, 2019Silver Contributor
One way is by using a pivot table. See attached.
- JKPieterseMar 13, 2019Silver ContributorOh, and if you're on the latest version you can use =SORT(UNIQUE(TheRange)) to get a sorted list of unique items.