RobcPettit wrote:
I think you were right in thinking that you might have to make a custom
function. You might try posting in the excel worksheet functions group.
The folks in there are quite clever and might be able to solve your
problem without having to code it.

HTH