The UNIQUE formula, in #excel, makes short work of removing duplicates from a list.
It comes in two main formats, determined by the third input. You can totally remove any items that appear more than once in your list, as below, or just keep one copy of each item.
=UNIQUE(The range that has the values you are interested in, optional input: True-if your data is in different columns otherwise False-which is the default, optional input: True if you want only values that occur once otherwise False – which is the default)
The second Bob has been removed from the list.
This is another example of a formula that will SPILL into other cells.