You can use the Data=Filter=Advanced filter, checking the uniques checkbox
and copy to another location to get a list of your uniques. If you start
from the destination sheet, you can have the data filter put the information
on another sheet. You need to specify the three columns that form the
unique data.

You can then put in a sumproduct formula next to these unique entries to sum
up.

=sumproduct(--(Sheet1!$A$1:$A$200=A1),--(Sheet1!$B$1:$B$200=B1),--(Sheet1!$C
$1:$C$200=C1),$D$1:$D$200)

then drag fill it down the list.

If you just want a count of the rows (which is what you described), remove
the last argument.

=sumproduct(--(Sheet1!$A$1:$A$200=A1),--(Sheet1!$B$1:$B$200=B1),--(Sheet1!$C
$1:$C$200=C1))


--
Regards,
Tom Ogilvy


mattis2k wrote in message
...

Hi,

Firstly I'd like to thank the people on here for replying so quickly,
its a great facility

I have a problem with a order worksheet in my workbook..

basically, it allows products to be added into a summary, where it
lists the model, description and quantity.

What I want is to merge the duplicate rows, and increment the quantity
field.

So if i have 3 rows the same, it will filter to one row and put "3" in
the quantity field..

can anyone help..?

Matt


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/