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