Finding first number in a row
 

Hi,

I have a spreadsheet with numbers scattered randomly within each row e.g.

Jan Feb Mar Apr May
172 200 500
20 30 40

I am trying to create a formula that will bring back the first number within
each row. In the case above, the first row would bring back 172, the second
row would bring back 20 and so on. I would be extremely grateful if someone
would kindly let me know the formula in order for me to be able to do this

Finding first number in a row
 

Try

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

Array entered with Ctrl+Shift+Enter

Mike

"Cadders" wrote:

Hi,

I have a spreadsheet with numbers scattered randomly within each row e.g.

Jan Feb Mar Apr May
172 200 500
20 30 40

I am trying to create a formula that will bring back the first number within
each row. In the case above, the first row would bring back 172, the second
row would bring back 20 and so on. I would be extremely grateful if someone
would kindly let me know the formula in order for me to be able to do this

Finding first number in a row
 

Cheers Mike...works great...thanks for your quick response and help

"Mike H" wrote:

Try

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

Array entered with Ctrl+Shift+Enter

Mike

"Cadders" wrote:

Hi,

I have a spreadsheet with numbers scattered randomly within each row e.g.

Jan Feb Mar Apr May
172 200 500
20 30 40

I am trying to create a formula that will bring back the first number within
each row. In the case above, the first row would bring back 172, the second
row would bring back 20 and so on. I would be extremely grateful if someone
would kindly let me know the formula in order for me to be able to do this