Google Sheets - Finding highest value - But Contains Letters

by pSyToR   Last Updated February 13, 2018 07:03 AM

Good Day Everyone,

So I have a list of Customers and different orders, but unfortunately the order numbers are with letters but I'm still in need to find the "highest" value... For example - 1-A - 2-B - 3-C

3-C is the highest...

Google sheets is able to manage with this cause I've used in other Situation 1-A > 2-B and I get false and when I use 2-B > 1-A it gives me true...

Do you have any idea how I can find the highest "number"

Thanks

Tags : google-sheets


Related Questions