Hi Domenic,

I made what I thought to be the necessary changes (amended Array2 and Array4)
but getting #Value! error in 1st cell and #REF! error in 2nd cell.

Could you possibly provide a note of the necessary amendments.

Also, using sample file with single column of data to match zero (0)
EmptyText rows, Formula returns #REF! error.

Further assistance appreciated.

Cheers,
Sam

Domenic wrote:
The error probably has to do with the reference for the appropriate
range within your named range 'Data', which spans a number of rows and
columns. So you'll need to replace the named range 'Data' in my
formula, which just refers to a single column, with the appropriate
reference for your worksheet.

You had mention that you will be copying the formula down the column.
If you want to pick up an new column each time the formula is copied to
the next cell below, I think you'll need to replace 'Data' in my formula
with INDEX(Data,0,ROWS(BA$7:BA7)).

Yes, picking up new column each time the formula is copied to
the next cell below.

If, however, you want to pick up a
new column each time the formula is copied across instead of down,
replace 'Data' with INDEX(Data,0,COLUMNS($BA7:BA7)).

--
Message posted via http://www.officekb.com