Numerical List Sorting - Binary Order

    Hello everyone


    Is there anyway to sort a list of numbers in Excel in Binary order


    ie
    2
    32
    11
    19


    would become
    11
    19
    2
    32


    not
    2
    11
    19
    32


    Thanks for reading


    B

    Re: Numerical List Sorting - Binary Order


    Hello Bertie,


    What kind of binary are we talking about, here? Here's what I get:


    Code
    2	=	10
11	=	1011
19	=	10011
32	=	100000

    Regards,
    Nate Oliver

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login