The data has numbers in text format and texts with numbers.
How do I find the max of the numbers in text format without converting to numbers?
How do I find the max if it contains certain texts (ie, if it contains only
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
You can use
Match to get the reference to the max item in the array and return the matching item from C.
I don't like this approach as your declaring an array twice so the computation is more expensive, I would suggest the answer by @marikamitsos
=INDEX(C2:C9,MATCH(MAX( ARRAYFORMULA(INT(IFERROR(REGEXEXTRACT(C2:C9,"NB(\d+)"),0)))), ARRAYFORMULA(INT(IFERROR(REGEXEXTRACT(C2:C9,"NB(\d+)"),0))),0)) NB667
NBmatches the characters NB literally (case sensitive)
\d+matches a digit (equal to [0-9])
+Quantifier — Matches between one and unlimited times, as many times as possible, giving back as needed (greedy)