I'm looking for a way to find the largest ID number in my ID column, but the normal MAX, doesn't seem to work.

The IDs are
REQ-001
REQ-002
..and so on

I just want a formula to return the highest/largest REQ-XXX in a cell at the top of the worksheet.

Any suggestions?

Thanks