PDA

View Full Version : Select Unique values from a coulmn



rajesh nag
08-25-2008, 11:00 PM
Hi,

I would like to select a unique value from one column and sum their values in another column. and build a chart

for example

Country Product Sales
USA Rice 544
UK Sugar 236
Canada Wheet 534
Srilanka Rice 673
UAE Wheet 432

i Should get

Rice 1217
Sugar 236
Wheet 966

I am able to get the sum of values using

=SUMIF(B$1:B$500,"="&B1,c$1:c$500)

and removing duplicates with ASAP

since their will be regular additions and deletions of rows in the columns

Can any one help me to select unique value from prduct column. Without using peot table and macros.


Regards,
Rajesh.

Bob Phillips
08-26-2008, 01:12 AM
Use Data>Filter>Advanced Filter, that has an option to get unique values and copy them to a new location.