View Single Post
 
Old 01-04-2024, 05:48 PM
Matin Matin is offline Windows 11 Office 2016
Novice
 
Join Date: Jan 2024
Posts: 17
Matin is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
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
File Type: png _xlfn.png (98.5 KB, 8 views)
Reply With Quote