Find Max number value from text-number cell?

B.W.B. · 2016-09-08T13:50:22+01:00

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:

B.W.B.
Sep 8th 2016

XOR LX

Intermediate

Points

1,805

Posts

357
Sep 26th 2016
- #21
Re: Find Max number value from text-number cell?

Ah, in that case - good! :smile:
- 1
- 2Page 2 of 2

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Facebook
Twitter
Reddit
WhatsApp
LinkedIn
Pinterest
XING

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

Participate now!

Share