The UNIQUE function
AdvancedExpert
8 questions, about 15 minutes
Make a list without duplicates that grows by itself.
What we'll do
- Spilling formulas
- Avoiding the #SPILL! error
What you'll use
UNIQUECOUNTASORT
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
8questionsYou do it yourself