Understand what youre saying but this will be manual, my goal is to automate
it so the sheet automatically gives the user a summary of the sheet. Like the
example; unique brands and amounts sold. The original column must remain.


"Jarek Kujawa" wrote:

one way would be to select a column with the brands
then (Excel 2003) Data-Filter-Advanced Filter-Copy to other
location (define yr criteria range)-Select Unique records only

HIH

On 7 Maj, 10:52, willemeulen
wrote:
It there any way I can summarize the range of values from a column. The
column contains manny repeats of values, let say car brand etc I want to
summarize the totals per brand at the bottom. I am using the sumif functions
to get the total numbers but how can I automatically show all the brands of
the sheet.