=INDEX(A1:IV1,MATCH(TRUE,ISNUMBER(A1:IV1),0))

entered as an array formula using CNTRL-SHFT-ENTER rather than just the
ENTER key.
--
Gary''s Student - gsnu200801


"Anto111" wrote:

Hi guys,

I have a collection of weekly data organised into rows. Where I have no data
for that week i simply enter "-". What I need is a formula to locate the
first number that occurs in a designated row.

For example if my data is:

- - - 8 - 9 9 - 10

I would need the formula to simply pick up the number 8.

Many thanks in advance for your help,

Kind regards,

Ant