Trying to figure out if there is a low-impact way to add another variable into the Dynamic Sort that I've created in the attached example workbook. I've figured out how to dynamically sort by date/project name/amount via the index/match/aggregate function (with help from this forum) in the cells H6:K13, but want to see if there is an easy way to add 'Team' as a variable into the sort utilizing a driving cell (H7 in this case) along with driving date cell (H6).
Would love to keep the current functionality along with the ability to sort by Team.
Thanks in advance for your help.
Bookmarks