"starguy" wrote:
thank you very much Max for your time and effort. I will try it now on
my original workbook but it will take some time as I am also working on
another formula which also seems to be a long formula but that is not
an array.

Would suggest you try implementing the earlier array formula <g, which
should work fine and is, I believe the simpler/shorter route in this
instance. cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---