Ranking off 2 variables.

[filmhandler]

Rank	#	Team Name	Wins	Loss	PinCount	HDCP + Pins
3	1	Out for a good time	11	17	3846	4791
1	2	Pin Slayers	20	8	4715	5102
2	3	Knock Down	16	12	4223	4370
4	4	VACANT	9	19

So I need help with a Formula to calculate the rank you see here based on the #of Wins and then by PinCount. I can do Rank by wins, and right now it works fine, cause there are no ties, but if there is a tie for a position, the tie is broken by Pincount or HDCP + Pins.

What formula do I need for this?

 

[DRSteele]

See if this Excel article helps.

 

[filmhandler]

Okay, I've tried figuring out this xl2bb thing, and i don't know if i'm stupid or what. Can't get it to work. The table shown above is how the table currently looks with the following formula in the Rank Cells.

=RANK(V2,$V$2:$V$5)

Column V is the number of wins for each team. Column X is the total pin count, and Column Y is the total Handicap + Pin count.

I just would like to know how to incorporate it to ranking the total pin count if a team happens to tie for points won.

 

[DRSteele]

Well, you could read this article: this Excel article.

To figure out xl2bb, watch this video.

 

[filmhandler]

Okay, that helped me out. I think I got it. lets see if this work.

Striker Challenge Score Sheet.xlsx
	S	T	U	V	W	X	Y
1	Rank	#		Win	Loss	Pins Count	HDCP + Pins
2	3	1	Out For a Good Time	11	17	3,846	4,791
3	1	2	Pin Slayers	20	8	4,715	5,102
4	2	3	Knock Down	16	12	4,223	4,370
5	4	4	Vacant	9	19
Point Record

Cell Formulas
Range	Formula
V2:Y2	V2	=B12
V3:Y3	V3	=F12
V4:Y4	V4	=J12
S2:S5	S2	=RANK(V2,$V$2:$V$5)
V5:W5	V5	=N12