LinkBack URL
About LinkBacks
Please help with the following:
Column A Column B 01-023 =Right(D7,3) 04-223 =Right(D8,3) 08-056 =Right(D9,3)
I would like to get the following formula to work:
MAX(Column B)+1
I need the highest value from Column B +1
Thanks,
Yuriy
Please help with the following:
Column A Column B 01-023 =Right(D7,3) 04-223 =Right(D8,3) 08-056 =Right(D9,3)
I would like to get the following formula to work:
MAX(Column B)+1
I need the highest value from Column B +1
Thanks,
Yuriy
Last edited by YuriyBaron; 12-05-2017 at 04:14 PM.
Based on the sample that you shared, what should the result of the formula be?
You didn't show us what is in column D.
Taking your request literally would be this:
=MAX(B:B)+1
but I am assuming that isn't what you are looking for.
RIGHT function always returns a text value so if you change your formula in row 7 copied down to this:
=RIGHT(D7,3)+0
...then the +0 is converting it to a number. Now if you use MAX function on the results it should work as required
Audere est facere
The problem here is that the RIGHT function returns a text value - it might look like a number, but it is just a series of characters. You can convert the text value to a proper number (as Excel understands it) by just carrying out a bit of arithmetic like adding zero or multiplying by 1, like this:
B7: =RIGHT(D7,3)+0
and copying this down. Then your formula:
=MAX(B:B)+1
should work okay (ensure it is not in column B) If you want to display the leading zeroes in column B, then apply a Custom Format of 000 to those cells.
Hope this helps.
Pete
Yes!
I did not know that +0 would convert it to a number.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks