Re: ignore text in array formula 2

Hello Steve,

you're right, I'm on German locale, for you the ; should be , in the formula. Try Bill's solution.


Am 24.03.2012 20:42, schrieb greigsteve:

Have only just seen your reply Soeren due to a problem I had which I have
posted as a separate thread.

I have tried the expression you suggest and also a number of variants but
still cant get it to work although I can see the logic behind it. The
expression you suggested was changing H2 to

The example with the problem is :

Thank you, Steve

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]