Forum Discussion
Identify values and then display the content of the cell.
If your data including the headings are in cells B1:J8. The totals in row 9 then this function should work. See also the attached example file.
=INDEX(SORTBY(B1:J1,B9:J9,-1),SEQUENCE(3,3))A little more modern with the new WRAPROWS() function:
=WRAPROWS(SORTBY(B1:J1,B9:J9,-1),3)
dscheikey Many thanks for this, this worked almost perfectly. One question, is it possible to say, that if all these cells are zero, then nothing is shown in the
my three highest scoring team roles:
my three middle scoring team roles:
my three lowest scoring team roles:cells, I know this may cause some issues as some cells may be zero which will need to be shown, but only in the beginning will all cells be zero and so the form should not show any results.
Not sure if I explained that very well, please do ask questions if not. Again, thank you so much for this it does work amazingly and worse case scenario I can live with data being in the 9 boxes initially.
Best wishes
Nick
I had a look at this, and I don't think I explained it well, what I am looking for is if this grid shows all 0 (zero)
Then this table would be blank
The complicated bit is, that it should only be blank if all the rows and columns are blank and every other time show the results.
Hope that helps explain it a bit better.
Many thanks in advance for your help
Best wishes
Nick
