Good evening,
I ask for your help to find the maximum value in column B containing some text
In the attached file in A1 I manually entered the desired result
the maximum value of column B.
Thank you
Good evening,
I ask for your help to find the maximum value in column B containing some text
In the attached file in A1 I manually entered the desired result
the maximum value of column B.
Thank you
Is the max value only the last four digits of the text. Is the text always preceded by 12/? What would happen if there was different precedent?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi the final digits are 4 example 0001,0125...
is preceded by 2 digits which can be 12,15,18,20 ....
Yes, but do the preceding digits, ie. 12 ,15 etc. have any thing to do with determining the max number.
No, consider that the previous figures can indicate the last 2 digits of a year then we have the / and then that progressive 4-digit number but, not in order on the lines, the largest is not said to be in the last line yes can find in any cell of column B
Please try
=TEXT(MAX(INDEX(--TEXT(SUBSTITUTE(RIGHT(B2:B39,4),"/",),"0;;;\0"),)),"AA 00\/0000")
or only consider last 4 digit
=VLOOKUP(TEXT(MAX(INDEX(--TEXT(RIGHT(B2:B39,4),"0;;;\0"),)),"\*0000"),B2:B39,1,0)
Last edited by Bo_Ry; 06-25-2020 at 01:30 PM.
Hi Bo,
great that you solve my problems
Thank you, it works
goodbye see you soon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks