Finding first number in a row

C

Cadders

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
 
M

Mike H

Try

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

Array entered with Ctrl+Shift+Enter

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drag formula down from columns that go acros 3
Complex VLookup Formula 2
YTD budget formula based on current actual input 4
Find first and last cells in range, return info beside 3
vlookup in the row below the target row 2
Extracting data from Multiple columns to a Single row 3
Lookup Formula 2
Count Non-Empty Cells In Each Row 0

Top