Hi,

I hope someone can point me in the right direction here.

I have a 16,000 row worksheet that is pulled weekly from a database,
values aren't static. I need to be able to filter a column by unique
values and add quantities of values that aren't unique. For example:

Carrier Date Customer RA# Store SKU Quantity EA/CS
Yellow 7/20/07 Wa 000136 153 1
ea
Roadway 6/11/07 Wa 000136 154 1896 ea
Roadway 6/11/07 Wa 000136 154 5232 ea
Yellow 7/11/07 Wa 000136 154 6
ea
Yellow 8/1/07 Wa 000136 156 6 ea
YELLOW 7/11/07 Wa 000136 NA 1503 1
Yellow 7/20/07 Wa 000136 1503 2 ea

I need all non-unique SKUs hidden or filtered, but the quantities of
non unique SKUs totaled.

Thanks,
Josh