Removing duplicate rows; only showing the first row that contains a value

[Uganda]

I have a file with many rows of data and I only need to pick one row for each account number, how do I remove the duplicate rows (I basically want to pick the first row where the account number appears and remove the ones that follow). A snapshot of the data is below, I would basically only want to have two rows in this example; one for 1703 and another for 1739.

1703	93271.59	31/05/2015
1703	93271.59	31/05/2015
1703	93271.59	31/05/2015
1703	93271.59	31/05/2015
1739	140053	31/05/2015
1739	140053	31/05/2015
1739	140053	31/05/2015
1739	140053	31/05/2015
1739	140053	31/05/2015

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thanks in advance

 

[JoeMo]

If you are using Excel 2007 or a later version, look at Remove Duplicates on the Data Tab (Data>Data Tools> Remove Duplicates).

 

[kalak]

If you are using Excel 2007 or a later version, look at Remove Duplicates on the Data Tab (Data>Data Tools> Remove Duplicates).

Suppose you use first 6 rows of a couple of columns as follows:

Type in 4 10 10b 4 10 4 (space separated values) from A1 down
and
Type in a 10 4 4 10 a from B1 down


Looks to me like there's some duplicate rows on the sheet.
How would you remove them?

 

[kalak]

er .... bump