Transmit data from a list from one worksheet 1 to another list from worksheet 2 being sorted by the largest to the smallest of a numeric column

0

In worksheet 1 I have an occurrence list that has several columns from C to AI , I'm wanting to pass data from this list of column C6:C25 and AI6:AI25 to worksheet 2, to columns D6:D25 and E6:E25 , respectively, in an ordered way from largest to smallest and avoiding empty cells, since I need to construct a pareto chart by the data in 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 it gives error, in this example link

    
asked by anonymous 19.11.2015 / 14:18

0 answers