So how would Biff formula work/look??
Source: =OFFSET($A$1,,,SUMPRODUCT(--(LEN($A$1:$A$10)0)))

--
Hayley


"Peo Sjoblom" wrote:

If you name your list you can use it in another sheet, insertnamedefine
and give it a name like MyList
then refer to it as

=MyList

in the source box

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com