Microsoft Office Tutorials and References
In Depth Information
Remove Duplicate Values from a Range or Table
Remove Duplicate Values
from a Range or Table
You can make your Excel data more accurate for
analysis by removing any duplicate records. Duplicate
records throw off your calculations by including the
same data two or more times. To prevent this, you
should delete duplicate records. However, rather than
looking for duplicates manually, you can use the
Remove Duplicates command, which can quickly find
and remove duplicates in even the largest ranges or
tables.
Before you use the Remove Duplicates command, you
must decide what defines a duplicate record in your
data. That is, does every field have to be identical or
is it enough that only certain fields are identical?
Remove Duplicate Values from a Range or Table
1 Click a cell inside the range
or table.
2 Click the Data tab.
3 Click Remove Duplicates
(
).
Search JabSto ::




Custom Search