Thanks for the help, but it still does not work. I don't know what too
do!

As well as the Product column there are also other columns on sheet 1,
one of which is price. On another sheet i have descriptive statistics
formulas (e.g. mean median etc) that are linked to the prices on sheet
1. But i don't see why this should matter. I am trying to delete the
exceptions so that the descriptive statistics change.

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=509910