Try this (for clarity):


| A | B | C |
---|-------+-------------------------------------+----------------+
1 |ID Nos.| Formula to Get Numeric | Formula Result |
| | from End of "ID Nos." | Formula Result |
---|-------+-------------------------------------+----------------+
2 | t-199 | =VALUE(MID(A7,FIND("-",A7)+1,3)) | 199 |
---|-------+-------------------------------------+----------------+
3 | t-204 | =VALUE(MID(A7,FIND("-",A7)+1,3)) | 204 |
---|-------+-------------------------------------+----------------+
4 | t-382 | =VALUE(MID(A7,FIND("-",A7)+1,3)) | 382 |
---|-------+-------------------------------------+----------------+
5 | | | |
---|-------+-------------------------------------+----------------+
6 | | Formula to Get Largest Value C2:C4 | Formula Result |
---|-------+-------------------------------------+----------------+
7 | | =LARGE(C2:C4,1) | 382 |
---|-------+-------------------------------------+----------------+