Thank you for your reply. Maybe I chose the wrong examples - for my actual data it won't have the problem you specified above as they are all three digit numbers. Does this make a difference to the formula you posted?

Edit: Have just tried and that works great. Thanks very much Canapone.