Create summarized list from larger list
 

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!

Create summarized list from larger list
 

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

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

Hope this helps.

Pete

On Dec 9, 12:31*am, 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!

Create summarized list from larger list
 

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!