data sort in special

[amar502322]

hello everyone i have data in A column like this
+BBB
+BBBB
+B
+BB
+AA
A
+AAAA
+AAA

But i want to sort the in this way for example:-
+AAAA
+AAA
+AA
A
+B
+BB
+BBB
+BBBB

please anybody help???

[CRIMEDOG]

I love helper columns Add a column You can hide by making text color white... if(A1="+AAAA",1,if(A1="+AAA,2,If(A1="+AA",3,If(A1="A",4,if(A1="+B",5,IF(A1="+BB",6,IF(A1="+BBB",7,IF(A1="+BBBB",8,9))))))))
for the 9 you can add anything - like "Need to Score" or "" - but the sort may not work as well

Then sort by the helper column

Another way: create a chart with your options and their values - then use a look up to fill in the helper column

+AAAA..... 1
+AAA..... 2

Then vlookup(A1,Sheet2!A1:B8,2,False)

[kev_]

Also using helper columns

in B2 and copy down
=IF(LEFT(A2,1) ="+",A2,"+"&A2)
In C2 and copy down
=RIGHT(B2,1)&(1000-LEN(B2))

then sort [A to Z] on column C


1000-LEN(B2) - merely reverses the sequence

[amar502322]

hello kev_
why i am not able to attach any excel file for example. when i click on attachment option then it popups but did not go for file destination from computer location. anything which is to unlock for file attachment??

plz help

[amar502322]

please check anybody. i am very dispointed.

[kev_]

Please edit your previous post and do not give away your ID and password.

To attach a file, click on Reply, then "Go Advanced" then look below for "Manage Attachments" etc