Two ways...

  1. Data tab >> Data Tools >> Remove duplicates
  2. Data >> Sort & Filter >> Advanced >> Copy to another location >> List Range: (Select the range) >> Copy to: (Pick a cell for the output) >> Check Unique records only

There are other ways, but these two are probably the most straight forward without a formula or VBA