Wanting to get the latest cell in a row data

Jaffabfc

Board Regular
Joined
Jul 5, 2013
Messages
233
Office Version
  1. 365
Platform
  1. Windows
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
 
Put this in B22 and confirm with Ctrl+Shift+Enter . Excel will automatically put Braces { } around the formula.
Excel Formula:
=INDEX(E22:AO22,MATCH(2,1/(E22:AO22<>""),1))
 
Upvote 0
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
 
Upvote 0
Glad we could help & thanks for the feedback.
 
Upvote 0
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
1738578697431.png
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top