You're right, it did work in Excel but not in Google spreadsheets. Unfortunately it's required to be able to work in google spreadsheets, so would there perhaps be an alternative formula which may work in google? Feel free to try some out on the document posted above. THanks