Posts by UH_IT

    Re: Sort Two Columns Simultaneously


    Thanks for all the replies! It dawned on me like half an hour after I posted to simply copy whichever value wasn't a NULL into a 3rd column and to use that to sort like Trebor76 was saying.


    The reason for the blanks is that this is a budget/transaction history worksheet. In this particular case, one column is for encumbered transactions, while the others are actual transactions. A transaction in this case can only be of one type or another.


    I'll admit I'm more of a DB person, and pulling this info from a query gets me what I want in the right format, but unfortunately I just have these giant worksheets to work with, and I don't use Excel much beyond basics. :(


    Thanks again!

    Hello all,
    I'm not sure how to accomplish this seemingly simple task.


    I'm trying to sort selected rows by two columns, but simultaneously instead of sorting by "Column A and THEN Column B". In my case, this is numerical data where there is ONLY data in one column or the other, never both.


    For example:
    5 _
    10 _
    _ 1
    _ 6
    _ 4


    Should sort to:
    _ 1
    _ 4
    5 _
    _ 6
    10 _


    Thanks for any help.