Find first cell with data in a given row

[mjmoon]

I am entering data into one specific row representing each months total. I have 12 columns representing each month of the year. In column 13 or M I want it return the last months of data that was entered in.

To describe it better in A1 = 12 for January, A2 = 15 for February, A3 = 11 for March. I am looking for a formula that will look in the range A1:L1 and find the first cell (searching from right to left) with data in it. In the example it would be cell A3 and return the number 11.

Hopefully this makes sense.

 

[Haseeb Avarakkan]

Hello, try in M1

=LOOKUP(9E+300,A1:L1)

If you want to get non zero values

=LOOKUP(2,1/A1:L1,A1:L1)

 

[mjmoon]

Thanks. This is what I was looking for.