Create summarized list from larger list

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

 

[Pete_UK]

Make sure that your columns have headers, insertng a new row 1 if
necessary, then use Advanced Filter. Debra Dalgleish shows how here:

http://www.contextures.com/xladvfilter01.html#FilterUR

Hope this helps.

Pete

 

[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