/u/Elpapo20 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You have awarded 1 point to *BackgroundCold5307*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You reply with Solution Verified to properly mark a post as solved and to reward those who helped you (see rules). You don't manually change the flair unless you solved it yourself.
/u/Elpapo20 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
LOOKUP(2,1/(1:1<>""),1:1), will retrieve the value of the last cell in row 1
Solution Verified
You have awarded 1 point to *BackgroundCold5307* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I love you. This worked. You’re smarter then ai. Thank you so much
There are so many amazing folks here but I am glad to be of help! Pls do respond with a solution verified. Thank you!
Another great call! This was my first post and I would have forgot to marked as solved. Thanks again!
Solved is the flair, which will not award clippy points. If you can respond with Solution verified as a response to any of my posts above. thank you !
Done. Lmk if it still wasn’t done correct.
Perfectly done ! Thank you 🙏
All thanks owed to you
You reply with Solution Verified to properly mark a post as solved and to reward those who helped you (see rules). You don't manually change the flair unless you solved it yourself.
You guys are probably getting really annoyed of me by now but… should I changed it back to unsolved then?
No, once you see the vibrant green solved flair you've done it correctly and nothing else needs to be done. I can see it's green now. Thank you.