Hi,

Just highlight the range and create a pivot table. This will give you
exactly what you want.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"NC" wrote in message
...
I have a column where there are several variable, repeated many times.
On the right column the values of the variable ate given.
I want to add up all the values of each unique variable and get a table
that
has all unique variables in one column and their corresponding summed up
values on the next cell.