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

#25

01-04-2024, 05:48 PM

Matin

Windows 11 Calculate league standings in a fixture list

Office 2016

Novice

Join Date: Jan 2024

Posts: 17

Quote:

Originally Posted by p45cal

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?

Still getting NAME error.

Attached Images

_xlfn.png (98.5 KB, 10 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 04:50 AM.