ooger

#n/a means no matches found for the MATCH formlua, its fine as long as you can identify them as being seperate. I'd replace them with zeroes though cos itll make the sorting better.

Now you've done that select all, and choose copy, the select all and choose "Paste Special" and past the VALUES of the calcs only into the sheet ontop of whats there already. That removes the formulas, then you can begin sorting and deleting without worrying about it trying to recalc the lot as you work.

HTH