title: google sheets / excel duplicate high value in row -> index column issue
body: <p>excel....Table issue ... find duplicate high value in row and return column title
  I have the following table:</p>
  <p>_____apple      pear    plum    grape   cherry</p>
  <p>alice     __5   ____0   ___5    ___3    ____1</p>
  <p>bob ___2    ____1   ___0    ___1    ____2</p>
  <p>cindy   ___1    ____2   __3 ___6    _____4</p>
  <p>And I need to find duplicate high value in row and return column title. Otherwise return the max value.</p>
  <p>For example for row &quot;alice&quot; the 2 highest values are &quot;5&quot; so the 2 columns returned would be &quot;apple&quot; and &quot;plum&quot;</p>
  <p>for &quot;bob&quot; it would be &quot;apple&quot; and &quot;cherry&quot;</p>
  <p>For Cindy since there's only  &quot;grape&quot;</p>
  <p>I tried the following formula:   =index($B$1:$F$1, match (large(B2:F2,1),B2:F2,0))</p>
  <p>and it returns the first largest value, but I cant get the 2nd largest value with:   =index($B$1:$F$1, match (large(B2:F2,2),B2:F2,0))</p>
  <p>because it again returns &quot;apple&quot; as &quot;apple&quot; is seen as both the first and 2nd largest value.</p>
  <p>I tried the following formula to get the 2nd largest value in the first row:</p>
  <p>=index($B$1:$F$1, match (large(B2:F2,2),B2:F2,-1)) and it works to return &quot;plum&quot; for the first row, but for the second row instead of returning &quot;cherry&quot; it returns &quot;apple&quot;.</p>
  <p>=index($B$1:$F$1, match (large(B3:F3,1),B3:F3,-1)) atually return &quot;cherry&quot;</p>
  <p>but then i have different formulas in different rows and im confused. I need a consistent formula to get the two values.</p>
  <p>Please any help would be appreciated. see,s like it should be a simple problem. But I have been racking my brain.</p>