Hi Biff,

That's Brilliant! Your last formula provided the required result. Thank you
very much for your time and help.

T. Valko wrote:
Assume you want the results starting cell in C53:

Array entered** :

=IF(COLUMNS($C53:C53)<=COUNT($C50:$J50),INDEX($C5 0:$J50,SMALL(IF(ISNUMBER($C50:$J50),COLUMN($C50:$J 50)-MIN(COLUMN($C50:$J50))+1),COLUMNS($C53:C53))),"")

Copied across.

If the values are in ascending order as is depicted in your sample data then
you can use a less complicated array formula** :

=IF(COLUMNS($C53:C53)<=COUNT($C50:$J50),SMALL(IF( ISNUMBER($C50:$J50),$C50:$J50),COLUMNS($C53:C53)), "")

Even though my values were not in ascending order, the above, less
complicated formula returned my numeric values in ascending order.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Cheers,
Sam

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