Hi
what is the formula to get the last number on row A2 : 170227,170227,171225,171226,170227?
I just need the last number which is 170227
thanks in advance
Hi
what is the formula to get the last number on row A2 : 170227,170227,171225,171226,170227?
I just need the last number which is 170227
thanks in advance
Assuming that you mean ROW 2.... i.e. from A2 to F2, or whatever...
=LOOKUP(1E+100,2:2)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi Glenn,
thanks, but what I need is to get the results in Column B. for example
Column A
170227,170227,171225,171226,170227
Column B is the answer or result which is 170227. I just need to get the last number from given column A sample
Maybe this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Alkey's solution will give you what you want. However remember that ROW = horizontal, COLUMN = vertical, and in your first post you said ROW A2....
I have attached the file for reference.
I need your help guys.
You can use this formula
Formula:Please Login or Register to view this content.
But you need check the last value in cell A7. It is just a number formatted with commas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks