Anna's problem has been resolved.
Different locale settings for separator characters meant the formula needed
to be amended to take into account , and ; differences.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Andy Pope" wrote in message
...
If you want to email the workbook I will take a look.

andy AT andypope DOT info

Cheers
Andy

Anna S wrote:
Sorry, that was my mistake. But it does not work even with the formula
you sent me.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info