Wanting to get the latest cell in a row data

[Jaffabfc]

Hi,

I have several columns n several rows full of data.
Each month i add more data the the columns, so for example cells E22:E34 as dad for August F22:F34 will have September
In cells B22:B34 i am wanting the last inputted in cells E:AO

So for example B22 would show E22 figure but if i then enter in F22 i want it to show F22 figure G22 show G22 and son on.

I did put a formula in showing the Min as 99% of the time the figures will go down but sometimes they go up so it didnt work.

Can you help?

thanks

 

[AlphaFrog]

Put this in B22 and confirm with Ctrl+Shift+Enter . Excel will automatically put Braces { } around the formula.

=INDEX(E22:AO22,MATCH(2,1/(E22:AO22<>""),1))

 

[Fluff]

Another option

=LOOKUP(10^9,E22:AO22)

 

[Jaffabfc]

spot on both thanks, i was thinking the lookup but couldnt get my head round it.
the index match one i have never used it in that way so will look at learning that

thanks both

 

[Fluff]

Glad we could help & thanks for the feedback.