Thanks for your response.

The retrieved values will be used in a calculation. For example it
could be something as simple as the value of the 1st populated cell to
the left subtracted from the value of the 1st populated cell to the
right. To answer your other question, if there are no values to the
right (by default there is at least one value to the left) then all
values will equal the value to the nearest value to the left.

When you talk about a user defined function are you referring to a
function built using VBA? I'm looking for an approach not using VBA,
but will resort to it if I have to.

Good suggestion about using another hidden sheet. However, I'm trying
to stay away from this sort solution that uses additional rows. Yes, I
know, many constraints.


--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=562402