Hello,
I am struggling on creating correct formula to display top 3 and bottom 3 results and additional info relating to result in same row but different column.
I have tried using VLOOKUP or MATCH formulas to combine with LARGE/SMALL and OFFSET, but I'm not quite there yet.
I get the right SMALL/LARGE score to display and with OFFSET to show correct name, but there is a problem when I have same SMALL/LARGE result more than once. So I searched the forums and changed it a bit adding ROW formula and it worked almost. Now I get error when I have only one SMALL/LARGE value.
I attached copy of workbook and highlighted formula fields I'm struggling with. Yellow with LARGE results using array formula with ROW function I found on forum and adopted (probably wrong because I'm not 100% understood) and Green with my original choice using MATCH function.
Basically my aim is to display top 3 and bottom 3 team names according on their weekly performance increase an decrease. These results are displayed in Departmental sheet.
Thank you in advance and hoping to find solution for this problem without using macros if possible. If not I'll take advice for VBA also.
Bookmarks