How can I find the highest Alpha Numeric value

Ashu K

unread,

Jun 10, 2016, 3:54:19 AM6/10/16

to Excel VBA Lab - An Excel VBA Macro help Group

Dear Seniors,

How can I find the highest Alpha Numeric value from below data?

IT20140001

IT20140009

IT20140003

IT20140004

IT20140005

IT20140006

IT20140007

IT20140008

IT20140009

IT20140017

Thanks & Regards

Ashu Kenith

Ashish Kumar

unread,

Jun 10, 2016, 6:43:58 AM6/10/16

to Excel...@googlegroups.com

Hi,

Check this...!!

Note : Please visit on forum page for download the sheet.

Regards

Ashish

Highest - Alpha Numeric - Resolved by ExcelVbaLab.com.xlsx

Ashu K

unread,

Jun 11, 2016, 9:40:26 AM6/11/16

to Excel VBA Lab - An Excel VBA Macro help Group

Thankyou Sir, formula is working perfect.

Thanks & Regards

Ashu Kenith

Ashish Bhalara

unread,

Jun 13, 2016, 3:49:12 AM6/13/16

to Excel VBA Lab

Hi Ashu,

Try below array function by Ctr+Shift+Enter

=MAX(--RIGHT(A1:A10,8))

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab - An Excel VBA Macro help Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/96378bfb-c3ef-4208-b2bd-cfe8e3c51002%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all

Reply to author

Forward