Quote Originally Posted by José Augusto View Post
Hi Alkey
I tested your formula and it seems to me that is not correct. Can you test again?
I test another array formula that is too short
Formula: copy to clipboard
=MAX(IFERROR(MID(A1,FIND("RX",A1)+2,{4,3,2,1})*{1,1,1,1},0))

Best regards
Why would it be not correct? The results are fine

Data Range
A
B
1
12354165RX1595
1595
2
165163546RX15_G_B
15
3
165163546RX1235_G_B
1235
4
165163546RX1525_G_B
1525
5
165163546RX19
19