Hi

Every Excel come with VBA as far as I know. Perhaps you have an earlier version but there will be a way to enable it. Other than VBA, I cannot see a solution using formulas to what is a very good question.

Sorry
Alan