Deleting Duplicated Data

Resolved · Low Priority · Version 2003

Thu 20 May 2010, 15:09 Delegate Reema said...

Reema has attended:
Excel Intermediate course
Excel Introduction course

Deleting Duplicated Data

Hi,

Can you please give me some avice on how I can delete duplicated data from a spreadsheet.

Thanks

Reema

Fri 21 May 2010, 09:39 Trainer Stephen said...

RE: Deleting Duplicated Data

Hi Reema

Thanks for your question

Could you clarify your needs for me please? In particular how is the data organised? Are you looking to delete identical rows in a table, or simply duplicate values in a single column?

Thanks

Stephen

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Deleting Duplicated Data

Deleting Duplicated Data

RE: Deleting Duplicated Data

Excel articles

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010