The UNIQUE function

The UNIQUE function gives you a self-updating means of removing duplicates from another list. The =UNIQUE(C3:C12) formula in cell G3 of Figure 10.12 returns one of each country’s names from the list in cells C3:C12, spilling the results into cell G4 and beyond as needed:

Figure 10.12 – The UNIQUE function

The UNIQUE function has three arguments:

• Array – The range of cells that you wish to remove duplicates from, which, in this case, is cells C3:C12.
• by_col – An optional argument that defaults to TRUE, which instructs Excel to remove duplicates from columns. Use FALSE if you wish to instead remove duplicates across rows. In this case, I omitted the argument.
• exactly_once – An optional argument that defaults to TRUE to remove duplicates. Use FALSE if you wish to display every item from the original range. In this case, I omitted the argument.

The =UNIQUE(C3:C12,TRUE,FALSE) formula...