How to display top 2 items from a sheet.

[AmadorF3]

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.

[#2]

@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.

[#3]

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.

[#4]

@AmadorF3 

Perhaps you may submit sample file instead of screenshot?