In that case I'd say your automated system is wrong and trying to get your excel sheet to match up with something that is wrong is pretty futile.