Hello Ranman,

Thank you for your swift response.

I think you've proffered a rather advanced solution. As a neophyte in excel, creating a macro function could be a bit daunting. Nonetheless, I don't mind learning how to do that.

I'd do a little research here. I'd welcome a link to a thread that has a clear-cut explanation of how to create macro function.