Calculate league standings in a fixture list

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate league standings in a fixture list

FAQ

Thread Tools

Display Modes

#18

01-04-2024, 04:31 PM

p45cal

Windows 10 Calculate league standings in a fixture list

Office 2021

Expert

Join Date: Apr 2014

Posts: 963

In the attached, see formula at cell AI2:

Code:

=LET(rws,($D$2:$D$97=$D2)*($G$2:$G$97=$G2),TAKE(SORT(VSTACK(VALUE(TEXTSPLIT(TEXTJOIN("¬",TRUE,FILTER($N$2:$O$97,rws)),"¬")),VALUE(TEXTSPLIT(TEXTJOIN("¬",TRUE,FILTER($Z$2:$AA$97,rws)),"¬"))),2,-1,TRUE),1))

Copy down. It will spill to the right. I feel sure it could be more elegant.

Note that I used my shorter formula in msg#22 in cells AB2:AC25; it's more robust.

Attached Files

msofficeforums51391Position_in_rows_of_data.xlsx (24.2 KB, 3 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cross-reference with full context a numbered list inside another multilevel list (list style)	MatLcq	Word	0	02-01-2021 06:00 AM
Calculate a Date	shawn.low@cox.net	Mail Merge	5	12-12-2019 03:22 PM
are there any good free golf league programs out there	kener40	Other Software	0	03-28-2014 05:54 PM
calculate age	userman	Excel	8	06-02-2012 10:59 PM
Calculate formula base of list menu	rkeles	Excel	4	09-22-2010 12:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:54 PM.