See the bottom rows of the examples below. If the list of stores, regions etc change an automatic list of unique values will update automatically. There are two main reasons why it’s better to produce unique lists from the original data. After all, the question goes, “We know the list of departments, regions etc”, just type them in and move on. Why bother?Ī surprising question about making a unique list is why it’s even necessary. There is a ‘unique’ option but it’s a ‘one off’ action that doesn’t refresh. We’re talking here about making a list of unique (non-duplicate) values which update automatically if the source list changes.
The best option is a lot easier but not yet available to everyone. One is headspinningly hard and one has some minor quibbles. Making a list of unique or not duplicated names from a longer Excel list with duplicates is possible in three ways that update automatically. Thanks for joining us! You'll get a welcome message in a few moments.
