Delete duplicate entries in Excel 2007
If you have to import data at work, the data is usually in Excel. The catch is that there are often duplicates (duplicate entries). It is more difficult with older versions of Excel than with Excel 2007.
First mark the data area.
Then the register Data> Remove Duplicates click. In the window that opens, select one or more columns where the duplicate entries are located that should be removed.
In my example we only tick the column E and after confirming we get the following message: "2 duplicate values were found and removed. 2 unique values are retained."
Four-color Excel
|
Confirm with OK, then you should get the following result:
Questions about Office or especially Excel click here
more interesting Excel tips:
- Include Excel graphic in the header
- Rotate Excel table (transpose)
- Enter numbers as text / display leading zeros
Transparency: | This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de. |
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille
Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.