How to display top 2 items from a sheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-3019488%22%20slang%3D%22en-US%22%3EHow%20to%20display%20top%202%20items%20from%20a%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3019488%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20rank%20items%20from%20a%20sheet%20and%20display%20the%20top%202(for%20example)%20on%20how%20well%20they%20are%20doing.%26nbsp%3B%20On%20the%20example%20I'm%20trying%20to%20rank%20the%20items%20on%20the%20left(A-1%2C%20A-2%2C%20A-3%2C%20A-4)%20going%20from%20left%20to%20right%2C%20I'm%20trying%20to%20have%20the%20receiver%20box%20at%20the%20bottom%20display%20the%20top%20performing%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3019488%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3020125%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20display%20top%202%20items%20from%20a%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3020125%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1233900%22%20target%3D%22_blank%22%3E%40AmadorF3%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20you%20may%20create%20helper%20column%20to%20COUNTIF()%20number%20of%20%22Compliant%22%20and%20lookup%20name%20on%20LARGE()%20n.%20Also%20depends%20on%20your%20Excel%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3020250%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20display%20top%202%20items%20from%20a%20sheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3020250%22%20slang%3D%22en-US%22%3EI'm%20running%20Excel%202016.%20I%20see%2C%20how%20would%20I%20type%20that%20out%20in%20formula%20format%3F%20I'm%20not%20really%20experienced%20with%20excel%20formulas%20and%20am%20trying%20to%20get%20the%20hang%20of%20the%20functions.%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

 

I'm trying to rank items from a sheet and display the top 2(for example) on how well they are doing.  On the example I'm trying to rank the items on the left(A-1, A-2, A-3, A-4) going from left to right, I'm trying to have the receiver box at the bottom display the top performing items.

 

3 Replies

@AmadorF3 

As variant you may create helper column to COUNTIF() number of "Compliant" and lookup name on LARGE() n. Also depends on your Excel version.

I'm running Excel 2016. I see, how would I type that out in formula format? I'm not really experienced with excel formulas and am trying to get the hang of the functions.

@AmadorF3 

Perhaps you may submit sample file instead of screenshot?