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.