DynamicSort.png


Hello all,

I'm attempting to reorganize the left table(which will eventually become hidden) into the right table to be sorted by rank(staring at 1, going to 20). Depending upon the position selected(E2:G3 DropDown List), the rank in the left table(column A under 'Rank')will change often, causing the order to change. I want the the office # and the corresponding count to transfer to the Table on the right accordingly but have ran into multiple issues when trying to INDEX the data. I would like to avoid clicking between each position selection and try to make this automatic.

Any recommendations would be greatly appreciated!