Paul .A - 2016-10-12

Hi, Everyone. First let me introduce my self I'm not a programmer and But lately my work need to sort the excel value as logistic is our business nature. Well I can sort the value in Exel by using DATA > Sort the appointed column. But the excel file is received daily new. I not really fancy to resetup everytime. HERE Is What I need on BELOW SAMPLE. I need to sort single whole column with Alphanumeric value and Get the first and last alphanumeric value. Then I need the total count example: 2HGxxxxxxx are total 10 while 2XUxxxxxxx are total 6. unexpected detection as it starts from 2X8. All below always use the Fix 2HG, 2X8 and 2XU

2HG108597601824 (1st I need front 8 cha 2HG1085976) 2HG Total Count 10
2HG108597701823
2HG108597801822
2HG108597901821
2HG108598001827
2HG108598101826
2HG108598201825
2HG108598301824
2HG108598401823
2HG108598501822
2HG108598601821 (Last I need front 8 cha 2HG1085986)
2X8100186001827 )Extra/ unexpected value here ) 2X8 Total Count 1
2XU100999101821 (1st I need front 8 cha 2XU1009991 ) 2XU Total Count 6
2XU101002401824
2XU101002501823
2XU101002601822
2XU101004501827
2XU101005301826 (Last I need front 8 cha 2XU1010053)

=========================================================================================
I hope to created a program to BROWSE above excel file and it auto or manual select Column A as input. Below are the output I'm hope to create.

Start: 2HG1085976
End: 2HG1085986
Total Count: 10

Start: 2XU1009991
End: 2XU1010053
Total Count: 6

Unexpected List: 2X8100186001827 (Full)
(List it If have more)
Total Count: 1

Thank You :-)

 

Last edit: Paul .A 2016-10-12