Morning, Peter!
The same thing applies to this as your abbreviated words thread: you need to be able to explain the logic in the choice of words you are making. Remember that Excel is software that you have to programme, so it needs a set of rules to work by if you want it to do this sort of thing using a formula, or VBA, for that matter. Without a set of rules that you can explain, it's a non-starter. So, what's the logic in the sample?
Bookmarks