Using RANK, INDEX and MATCH

[Dearster]

Can anyone help me using RANK, INDEX and MATCH.

Basically I have 3 seperate values, 2 in one column and 1 in another column. These values relate to a department name. I want to make a leader board list of the department names. So I would need to connect the names to the values and then rank the values and output the rank.

Thank you.

 

[aravindhan_31]

Hi,

Give an example..

 

[Dearster]

3 department names: Bakery, Fresh Foods, Produce.

3 values as percentages.

I need to link the percentage values to the department somehow.

Example Ranked List

1st Bakery
2nd Fresh Foods
3rd Produce

List dependent upon the higher percentage.

 

[aravindhan_31]

To get result like this in ColC or anywhere
ColA-- ColB----- ColC
%----- Dept---- Rank
10%--- Bakey----Produce-25%
5%---- Fresh----Bakey-10%
25%--- Produce--Fresh-5%

use the formula like this for highest

=VLOOKUP(LARGE($A$2:$A$4,1),$A$2:$B$4,2,0)&"-"&(LARGE($A$2:$A$4,1)*100)&"%"

=VLOOKUP(LARGE($A$2:$A$4,2),$A$2:$B$4,2,0)&"-"&(LARGE($A$2:$A$4,2)*100)&"%"

large function will give you the highest value in a range defined by the numbers like
(LARGE($A$2:$A$4,1)
(LARGE($A$2:$A$4,2)
(LARGE($A$2:$A$4,3) etc

I dont know how your worksheets looks, post a sample using HTML maker or send an email to mail.aravindhan@gmail.com

 

[Dearster]

I've sent you an email because I'm unsure how this would work.