Hi Rick,

Thanks a lot for your information. It was working on my excel with
your formula. I am trying to digest what is the function doing.

Thanks a lot!

Rick Rothstein (MVP - VB) wrote:
If you are using XL2003 or earlier, no... array functions can't use a
full row or column reference in XL2007 you can use it, but you
probably shouldn't... making the array iterate over all the rows in
the column is not as efficient as limiting the iterations over the
maximum number of rows that will ever be used.

Rick