top 10 list showing both count and name
I have a row that contains user names and then a second row that contains counts associated with each user name. I want to be able to look at these two rows and create a top 10 list that shows the top 10 counts as well as the user names associated with these top 10 counts. I have the formula for getting the top 10 counts but I'm having trouble creating the formula for grabbing the user names associated with these top 10 counts. An additional challenge is that there may be more than one user with the same count so that needs to be considered as well.
Here is the formula for the counts - =LARGE($[Column8]$2:$[Column337]$2, ([Column8]@row))
I already have this working as an array formula in an Excel sheet but the Excel formula is not translating over to Smartsheet so I'm guessing something in the Excel formula is not supported in Smartsheet. I've tried manipulating the formula several different ways but cannot figure out what I need to do.
Here is the Excel formula after translating into Smartsheet format:
=INDEX($[Column8]$1:$[Column337]$1, MATCH(1, ($[Column8]$2:$[Column337]$2 = LARGE($[Column8]$2:$[Column337]$2, [Column8]@row)) * (COUNTIF($[Column10]9:[Column10]9, $[Column8]$1:$[Column337]$1) = 0), 0))
This returns "#INVALID OPERATION" error.
Any assistance would be greatly appreciated.