# Max in column with text

1. ## Max in column with text

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

2. ## Re: Max in column with text

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?

3. ## Re: Max in column with text

Hi the final digits are 4 example 0001,0125...
is preceded by 2 digits which can be 12,15,18,20 ....

4. ## Re: Max in column with text

Yes, but do the preceding digits, ie. 12 ,15 etc. have any thing to do with determining the max number.

5. ## Re: Max in column with text

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

6. ## Re: Max in column with text

=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)

7. ## Re: Max in column with text

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)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1