excel151515
New Member
- Joined
- Apr 17, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I am unsuccessfully trying to make a table autosort, and hoping to find an answer here. I have one table which has 3 items, a price for the item, and each item has multiple characteristics, as follows. The arrows illustrate the adjustment that is being made based on the percentage input below it. I then have a second table, does not include the percentage rows, and has the arrows linked to the arrows of this table. I then have to manually use the filter function, and sort the Price column from high to low, in order for the chart to appear how I want for pasting into word. Is there a way to automate this second chart, so that it can be auto sorted from high to low based on the original chart.
Thank you,
Thank you,
Item No. | Price | Weather | Time | Size | Shape | Overall |
1 | 100 | ↑ | ↑ | ↑ | ↑ | |
5% | 5% | -5% | 5% | 10% | ||
2 | 200 | ↑ | ↑ | ↑ | ↑ | ↑ |
5% | 10% | 5% | 10% | 30% | ||
3 | 50 | ↓ | ↓ | = | = | ↓ |
-5% | -5% | 0% | 0% | -20% |