Is there a function or series of functions that would enable me to automatically sort a table as data is changed. I have a table that includes three columns - Priority, Months, Rate. These values are all changed based on various other calculations happening throughout the workbook. Essentially, the data then looks like this:
6 13 6.2%
1 20 6.1%
5 34 4.5%
7 13 12.3%
2 21 5.5%
4 27 3.7%
3 13 6.2%
The table needs to be sorted based on the Months. However, notice the duplicates. What I need to have happen is that if there are duplicates, then it needs to sort those duplicates based on the Rate. If there are duplicates again, then I need it to finally sort by Priority. My brain is fried and I could really use someone's guidance to accomplish this. I would prefer not to use any Macros since this Workbook is going to be distributed among a few different folks and I cannot guarantee people will allow it to run. My goal is to then pull the "sorted" order and use it elsewhere in my book. Thanks in advance.
6 13 6.2%
1 20 6.1%
5 34 4.5%
7 13 12.3%
2 21 5.5%
4 27 3.7%
3 13 6.2%
The table needs to be sorted based on the Months. However, notice the duplicates. What I need to have happen is that if there are duplicates, then it needs to sort those duplicates based on the Rate. If there are duplicates again, then I need it to finally sort by Priority. My brain is fried and I could really use someone's guidance to accomplish this. I would prefer not to use any Macros since this Workbook is going to be distributed among a few different folks and I cannot guarantee people will allow it to run. My goal is to then pull the "sorted" order and use it elsewhere in my book. Thanks in advance.
