MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Summarize data (removing double lines)


Posted by Manuel Allaert on February 07, 2002 1:44 AM

I have a list in the following format

A I XXX
A I XXX
A I XXX
A J XXX
A J XXX
A K XXX
B J YYY
B J YYY
B K YYY
B K YYY

Basically I have redundant data due to repeated info
I want to summarize the list keeping one line for each unique combination of column A and B

A I XXXX
A J XXXX
A K XXXX
B I YYYY
B K YYYY
C ...

I don't wanna use the subtotals or a pivot table function because I then loose the text info of column C
I don't need counts, just at list of the unique combinations

Any ideas how to solve this problem ?
Manu


Posted by Chris D on February 07, 2002 12:57 PM

hmmm..

will data / filter / advanced filter help ?

highlight your entire range (including headings)

click :

data
filter
advanced filter
action = copy to another location
list range = your highlighted range
unique records only = yes
copy to = where you want to put your unique records

click okay

it should copy only unique rows of info

is this what you had in mind ?

Chris