0
In sheet 1 I have an occurrence list that has several columns of C to AI, I’m looking forward to going over the data from this column list C6:C25 and AI6:AI25 for spreadsheet 2, for columns D6:D25 and E6:E25, respectively, in an orderly way from the largest to the smallest and avoiding empty cells, because it is necessary to construct a graph of Right by the data of worksheet 2.
I found a formula
=SEERRO(ÍNDICE('Folha de Verificação'!C$6:C$25;MENOR(SE(ÉCÉL.VAZIA('Folha de
Verificação'!$C$6:$C$25);"";CORRESP('Folha de
Verificação'!C$6:C$25;'Folha de
Verificação'!C$6:C$25;0));LIN(1:1)));"ERRO"),
but she giving error, in this example https://br.answers.yahoo.com/question/index?qid=20140619133050AAyGyIR
Did you press Ctrl+Shift+Enter in the formula cell? Because it is an array formula. If you press only Enter it will not work properly.
– Math
It worked, but number 7 went to E26 and not E7. And another thing, as I bring it in order from the highest to the lowest?
– pedrosalpr