On Thu, 29 Dec 2005 21:28:35 +0900, "kounoike" wrote:

Hi DHANANJAY

you're welcome.
but, Ron has showed us more simple and flexible solution.
thanks Ron for introducing a very useful web site.

by the way, Ron's formula works fine and applied it to the case which has
plural match. The manual says it can be used as array function, so i entered
as array formula but i could'nt get every matches, only first match.
Of course, i can get every match using index parameter, or i've misread
the manual?

i'll appreciate if someone show me the way.

Thanks
keizi

I don't see what you mean when you say "plural match" in the examples given.
In the examples given, I see no need for an array form.

Perhaps I am missing something?
--ron