Rank using Max with data in different cells.

[heuder]

Hi guys,

Attached and example of what I'm trying to do.
I think the idea is pretty straight Forward...

Thkz ^^

[ragulduy]

It would be a lot easier if you put the data in a column (i.e. in D3:E14 as one list). Then you could use these formula:

in a3:
=RANK(VLOOKUP(B3,D$3:E$14,2,0),E$3:E$14)

then in B3 as an array formula (confirm with ctrl+shift+enter)
=INDEX(D$3:D$14,MATCH(LARGE(D$3:E$14,ROW(A1)),IF(COUNTIF($B$2:B2,D$3:D$14)=0,E$3:E$14,0),0))

Have a look at the attachment for an example

[heuder]

Here is the workbook I'm working on.

So, I can't really put all in one colum.

So.. the "ind" stand for "indicator", it would be the "cake.. candy" part.
So, each one of the 24 indicators has a number of violations, and I want to make a rank to show the top five indicators that has more violations.

Maybe I could use the table from "dados", but I don't know how. I would have to make a formula that sum with conditions and them find the max value... I could make a new table but I want to avoid to, if possible.

[ragulduy]

I still think it would be simpler to put it in one column (use helper columns and hide them, like in the example attached).