Solved!
Thanks for your interest, but I found the solution via an online Auto Bot - took some time, but very well worth it!
Apparently it can only be done via a Macro, as Excel only works in one-dimension for certain functions.
(Please don't ask me - the Bot suggested that!)
I have to say that this was my first experience of interaction with AI (at least as far as I was consciously aware) - great in the right hands.
|