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.

 

[Jaffabfc]

Hi,

Just coming back to this post, as its kind of the same thing i am wanting just in conditional formatting.

So for example b6-m6 has data and one reaches zero i am wanting conditional formatting to make cell a6 green with bold writing and strikethrough.
and then i would drag it down from a6 to a23.

I have put this in conditional fortmatting but its not accepting it
=if(LOOKUP(10^9,B6:M6)=0

 

[Jaffabfc]

haha worked it out, removed the if( and it worked