I used Barb's formula, but now am getting #N/A!. Also, should have
mentioned, my range names are a formula so they are dynamic, which is as
follows:

PHYNO =OFFSET(all07_08!$F$2,0,0,COUNTA(all07_08!$F:$F),1 )
SURGDT =OFFSET(all07_08!$A$2,0,0,COUNTA(all07_08!$A:$A),1 )
TYPE =OFFSET(all07_08!$C$2,0,0,COUNTA(all07_08!$C:$C),1 )


"TomPl" wrote:

Your formula works perfectly.

Make sure that each of your named ranges contain the same number of cells.

Tom