Originally Posted by José Augusto 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: =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
=MAX(IFERROR(MID(A1,FIND("RX",A1)+2,{4,3,2,1})*{1,1,1,1},0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
Bookmarks