zhshqzyc
asked on
Sort excel cells by length of the strings
Hello friends,
How are you? Attached is an excel file. What I want is:
1) sort the column by the length. If the string length is 1, it will be put in the first row, so and forth.
2) remove the duplicated rows.
Thanks for help.
multithread-pattern1.txt
How are you? Attached is an excel file. What I want is:
1) sort the column by the length. If the string length is 1, it will be put in the first row, so and forth.
2) remove the duplicated rows.
Thanks for help.
multithread-pattern1.txt
ASKER
Okay. There we go.
multithread-pattern1.xls
multithread-pattern1.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
her is sorted file, btw all were 11 long
multithread-pattern1-1-.xlsx
multithread-pattern1-1-.xlsx
Please attached excel workbook,
KK,