So I'm trying to build a spell list for a table top game that I can quickly and easily find the information I need on my phone while we're sitting at the table.
I have 5 columns of information
Prep? Lvl Name Effect FALSE Unchecked Box 1 Calm Animals Spell Description TRUE Checked Box 3 Remove Curse Spell Description
Just as a quick sample. Off to the right in columns K and L I have other information that ties into Concatenated formulas throughout the sheet, so I DO NOT want this information to move. So here's what I need, and I can't for the life of me figure it out;
Based on whether Column A is TRUE or FALSE (I.e. Whether the checkbox in the Prepared? column is Checked or Unchecked) I need the data in A2 through E87 to automatically sort every time a change is made in column A. It needs to be any change, because I'm not adding or removing any data from this spreadsheet. Whenever the data in column A changes I need it to sort all TRUE cells to the top of the list. Ideally I'd like this to only function on Sheet 1, as I have other information on Sheet 2 that doesn't need to be sorted. But if it doesn't work like that then I'll deal.
What else I'd like, if this is possible but it is much less important overall, is for it to automatically further refine the sorting. I.E. Spells are first sorted by True or False, then sorted by the level in Column C, and then finally sorted Alphabetically by the name listed in Column D. That's probably a little complex, and since I don't use Excel all that often I don't even begin to know if this is possible, but his seems like the place to ask.
Thank you so much for your help in advance!
Bookmarks