Let’s say one of the seven dwarves has gone walkabout, the new automatically made list of values removes ‘Doc’ automatically (left).įar easier to copy and paste one of these formula (one with a table reference) then change the parameters to suit. 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 that automatically update 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 table filtering 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 and relatively new in Excel. Making unique (not duplicated) list in Excel is possible in three ways that update automatically.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |