Hi mattwally,

I think a calculated field is the best option.

What problems did you have with it?

Can you post an Excel file with dummy data to work on showing what you've got now & what you want it to look like?

Thanks