It does, indeed, strike me that you should have been able to do this with a formula in Excel.