I have a report that I put together each week with performance measures for a number of locations. The report is pulled down from a third party website and is in Excel format but not the format that I need. In the attached example; column A, B & C are how the data comes in. (There are 5 more performance measures that would appear in adjacent rows but for simplicity sake, I have only included two) Columns F&G and I&J represent how I need it to look. G & J use the LARGE formula to sort the data highest to lowest and I think that formula is okay. Columns F & I need to have the location name from column A that correlates to the ranking number. I have managed to use VLOOKUP to return the number but not that name. As the title suggests, I think I'm close but not quite there. Suggestions for any formulas/approaches are welcome. - Thanks!
Bookmarks