My spreadsheet, attached below I hope, allows me to report and compare a number of organisation over a series of measures. There are input sheets for the measures (I1, I2 etc), the data from these input sheets feed through to the 'Current Metric' worksheet which is updated using the dropdown option shown on 'sheet 4'. The data from 'current Metric' populates the table on 'sheet 4'.
What I am having difficulty in is auto sorting the table by rank (column c) when the measure is changed using the drop down i.e. I want organisation displayed in ascending order based on the rank for measure 1 and when changed to measure 2 the table will automatically re-rank for that organistion who ranks 1 etc.
any assistance gratefully appreciated. Copy of Book1.xls
Bookmarks