I am looking for a way to change the order of a drop down list dynamically. Example:
First column is static (rank/priority). Drop down is in Col2. If I want to change the first row to Sample4, I will have two Sample4's. Is there a way that if I put Sample4 on the first row, it will swap out and put Sample1 where Sample4 is (was) or at least clear Sample1 to eliminate the duplicate? Same for the rest of the rows. My actual sheet has 18 rows of information. Essentially, I have formulas based on priorities and I need to model the data based on changing the priority order.
Thanks in advance for any help/advice.