Hello world!

Please, i need to find Max number value(MAX invoice number INV-2025/16) from three General(text-number) columns:

[TABLE="class: grid, width: 400"]

INV-2016/16

INV-2018/16

INV-2017/16

INV-2021/16

INV-2020/16

INV-2019/16

INV-2025/16

INV-2022/16

INV-2023/16

INV-2024/16

[/TABLE]

These columns are on different sheets.

=INDIRECT("S"&MAX(IF(NOT(ISBLANK(S:S));ROW(S:S)))) no to this formula 'cause it's **Volatile!**

{=IF(ISBLANK($P$5:$P$109);ROW($P$5);SUMPRODUCT(MAX((ROW($P$5:$P$109))*($P$5:$P$109<>"")))+1)} **this is promising**=RIGHT(A1;LEN(A1)-MIN(FIND({0;1;2;3;4;5;6;7;8;9};A1&"0123456789"))+2) this one for extracting numbers

INV-2023/16, INV-2024/16, INV-2025/16 which one is Max ??:cat: