I use the following array formula, which works fine, but if there is a error value (#N/A) in column B the formula returns #N/A. (Code, 1 line) I tried various ways to get over this and have failed every time, any help would be much appreciated. Many Thanks Alan