Explained in attached file how the array formula gives correct and wrong result.
I need to solve this issue in a same array formula.
Thanks in advance for any reply and help.
Please see attached file.
Best regards,
turist
Explained in attached file how the array formula gives correct and wrong result.
I need to solve this issue in a same array formula.
Thanks in advance for any reply and help.
Please see attached file.
Best regards,
turist
Here. I've shorten it.
another solution, with a UDF function
Dear zbor and Jean.P28
Thanks for prompt reply and great solutions(formula and macro)
Regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks