last man standing draw - excel file

Not sure about Excel, in Lotus 123, I used to do formulas that went something like if(cellreference)is not equal to X then NUll.

Do a search in the Excel help screen for a term called data validation. Look for something referring to applying data validation to a cell.

Yep, it should be like that.

= if(A1=X,"",X)

Where A1 is the cel reference and X is the amount you're looking to delete. The format of it is essentially saying, if we get the match correct, put in "" which is just two double quotes and nothing between them, e. g. null. But if it is not correct, just leave it alone. Hard to get it as the reference to what's exactly in the cel, though, e. g. if you were to change the number to X+1, you'd have to change this formula. There may be a way to reference to the amount in the cel, even if it's a variant, but that's more likely to be something possible (if at all) with VB Code.