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

#24

01-04-2024, 05:36 PM

p45cal

Windows 10 Calculate league standings in a fixture list

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

This should deal with VSTACK:

Code:

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

can you show a screenshot of the formula with _xlfn in it?
if LET is OK then rws should be too (it's only a variable).

« 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 10:15 AM.