Find and show the last value from a row

Hi.

I am hoping this is easy but knowing my history with Excel, It's probably not :D

I have attached the examplefile and what I want is a formula in the Z Column that gives me the last cell in the same row's value.

So for example In Z2 I want the text from D2 to be shown since thats the last cell in that row with information (except the formula from the Z Column of course) and then the same for Z3-Z11.
The file I am building will have about 150 row's to do the same with but a formula in Z2 finding the latest cell with text in it from row 2 and paste it there in Z2.

I hope this makes sense.
I am ok with adding another sheet and run the formula in there, as long as it still works as an o365 file uploaded to a sharepoint.

examplefile.xlsx

Thank you in advance!

Originally Posted by Pepe Le Mokko

Try

Formula:

Please Login or Register  to view this content.

and pull down
( change the ; to , if needed)

This worked great! Thank you! (I would assume others worked as well but since this worked I wont be testing all of them but I want to thank everyone for their contribution so far!)

As an addition. Which may make this way harder but this is something I just realized when I added this code to my file and saw it work.

In row 1 There will be timestamps (Worded: Timestamp: 2022-12-13 for example, manually written). above each info line. I have added a new examplefile with this first fix applied & working.
Examplefile 2.xlsx

So what I would want in AA is the Testheader that is the header for that cell which is returned in Z:Z.

Basically I want AA to show what the date is for the last comment made so the easiest way would be if AA2 for example check Z2, see's that the value is Info 4 and then shows the value for Info 4's header. If that makes sense?

I dont know if I should make a new thread or continue here? And mods/Smarter people please let me know.

Originally Posted by HansDouwe

If duplicate strings are possible, please try in AA2 nearly de same formula as in Z2 and copy down:

Formula:

Please Login or Register  to view this content.

This worked great Thank you very much!

Pepe I didnt get yours to work but that's probably due to my own lack of knowledge since the example file worked but I couldnt transfer it to my main file for some reason, but thank you for the effort & help!

This seems to have been all I needed for today so Ill mark it solved and add rep on you all, thank you all for the great and quick support!

And I will also check to make sure my version is correct everywhere (i usually work with the app, but this specific file needs to be usable on sharepoint but ill doublecheck!)

Again, thank you all and I wish you all a great and fantastic holiday season!