Custom Sort - Could not solve

[rakesh_sss]

Hi All,

I am quite new to excel. I have a requirment. I have rows of Data that comes from a source Something like below

#NULL#	30
Aerospace	50
Black	70
Catamarin	30
Total	210

<TBODY>
</TBODY>

This has to be sorted as below

Aerospace	50
Black	70
Catamarin	30
#NULL#	30
Total	210

<TBODY>
</TBODY>

Let me know how this can be achieved. I tried several ways.

Thanks​

Rakesh

 

[Michael M]

Create a custom List with A, B, C.....Z and then a # at the bottom
Assuming your data is in columns A and B, In column C put this formula

=LEFT(A1,1)

Now do a sort by custom List ( the list you created)

 

[rakesh_sss]

Hi,

This will sort data in A-z and # at the begining. My requirement is

Wherever the postion of #NULL and Total in the list , it should be placed at the bottom of the list with #NULL,Total ending the list.

Thanks