Hi,

2003
1. Select the two columns of data (with a title row) and choose Data,
Filter, Advanced Filter
2. Check the Unique records only box and click OK

This will hide all duplicates. You can copy the visible cells to another
location and do what you need with them.

2007
1. Select the two columns of data, with headers and choose Data, Remove
Duplicates, OK

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"tomhelle" wrote:

I have a long list of various components that I want to summarize. For example:

Column A Column B
Material 1 Thickness 1
Material 1 Thickness 2
Material 2 Thickness 1
Material 1 Thickness 1

I want to summarize this data so that it will produce a list as follows:

Column A Column B
Material 1 Thickness 1
Material 1 Thickness 2
Material 2 Thickness 1

Many thanks in advance!