I guess there are a couple of ways I could attack this problem. I
either need to be able to select cells that look blank but may not
actually be. Trying the 'goto/special/blanks' doesn't work even after
trying to paste special/values over the formulas in column C. Or I
need to be able to LEAVE the LAST duplicate cell in the list (i.e.
select all duplicate cells but the last one). This is what I have.

A B C
jeff 5
jeff 6
jeff 0 11
mike 3
mike 9 12

What's in column 'C' is a formula (=if(a1=a2,"",sumif(a$1:a2,a1,b
$1:b2)). I need someway to delete the rows that don't have a number
in column C.