Bernd,
Thank you thank you thank you. I figured it out. You are the best and it
is exactly what I am looking for......

"Bernd P" wrote:

Hello Eric,

The macros are intended to be used as they are - just press ALT + F11
in your Excel worksheet, enter a new module and copy my macro text in.
Then go back to your worksheet and enter the array formulas as shown
in my Examples (enter with CTRL + SHIFT + ENTER, not only with ENTER).

Again: If its easier to send me a file I am happy to complete a short
and an instructive example in your file.

Regards,
Bernd