Create summarized list from larger list

T

tomhelle

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!
 
S

Shane Devenshire

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
 
Top