List Ranking

[Peter1973]

Im trying to return a rank based on 3 columns :
In A1:A100 i have names, in B1:B100 i have a list of skills (for this they will be A,B,C or D), in C1:C100 i have a number.

I need to the formula to look in Column A for the colleagues then in column B for the skill and then return the rank from those who match both columns based on who has the highest number in column C.

Hope that makes sense any help appreciated.

 

[shift-del]

Hello Peter

What should be matched in column A?
Please provide either a mini sheet with XL2bb or a shared link to sample workbook.
And provide the intended outcome.

 

[Peter1973]

Your right column A is irrelevant its only column B and C so all the cells in column B with the same skill then their rank based on the value in column C with the highest value being the lowest rank.

 

[shift-del]

Mappe3
	F	G	H
1	Name	Skill	Number
2	Doris	A	88
3	Axel	A	5
4	Eva	B	6
5	Boris	C	55
6	Chris	D	44
7	Frank	D	33
Tabelle1

Cell Formulas
Range	Formula
F2:H7	F2	=SORT(SORT(A2:C7,3,-1),2,1)
Dynamic array formulas.

 

[Peter1973]

Thanks but how do i get in F to be a rank not the name ie Doris would be rank 2 and Axle rank 1?

 

[shift-del]

I ask you again to provide sample data with the expected outcome.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)