Auto sort standing as data is inputed

[jjhill051]

Rank	Player	GP	W	L	T	PTS	%	W	L	W	L	W	L	GS	GA	+/-
2	Jessi	10	6	2	2	14	0.700	0	0	1	0	0	0	2	1	1
3	Dan	1	1	0	0	2	1.000	0	0	1	0	0	0	2	1	1
1	Fil	9	6	1	2	14	0.778	0	1	0	0	0	0	1	2	-1

<tbody>
</tbody>

Rank is in Column A , (+/-) is in Column Q

Jessi is in row 4, Dan is row 5, Fil is row 6


Based off the Rank formula I have in A4-A6 (Ranks based on amount of points with a tie breaker on %) I want the standings to auto sort to rank the first place team on top and last on bottom as the data is inputed. So (B4-Q4) (B5-Q5) (B6-Q6) will move up and down based on the rank with each players stats staying with them. The Rank Formula will auto change already to reflect when they'll move.

Any help will be awesome!! Thannks

 

[jjhill051]

Bump

 

[jimrward]

Use INDEX and MATCH on the ranking

by the way bumping things is not a good practice Tends to render less responses

 

[jjhill051]

Use INDEX and MATCH on the ranking

by the way bumping things is not a good practice Tends to render less responses

=RANK(G4,$G$4:$G$6,0)+SUMPRODUCT(--($G$4:$G$6=G4),--($H$4:$H$6>H4))

That is my ranking formula.. how would I use the INDEX and MATCH on that?

P.s Good to know, wont bump in the future, sorry

 

[Smitty]

Welcome to the Board!

by the way bumping things is not a good practice Tends to render less responses

Bumping is ok, as long as a reasonable amount of time has passed, and you feel like your thread has fallen too far back to be noticed (like a page or two back). Bumping after less than an hour or so, on a holiday, or a Friday/Saturday night isn't the same though. And believe me, we've seen threads get bumped in less than 10 minutes...

A note on that is if your thread hasn't gotten any response, you might want to take a look to see if you've provided enough details. In the future you might want to use the HTML Maker (see the link in my sig) to post an actual shot of your sheet, including formulas.