Results 1 to 7 of 7

help with a BYROW

Threaded View

  1. 06-29-2023, 09:52 AM #2
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: help with a BYROW

    Please try
    Formula: copy to clipboard 
    =BYROW(D12:E13,LAMBDA(r,LET(
    
list1,TEXTSPLIT(INDEX(r,,1),","),
    
list2,TEXTSPLIT(INDEX(r,,2),","),
    
TEXTJOIN(", ",,FILTER(list1,ISNA(MATCH(list1,list2,0)),"")))))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] BYROW retrieve value in a dynamic array
    By guillaume0314 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-21-2023, 12:47 PM
  2. Combine two working formulae using BYROW (or other function(s))
    By TMS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2023, 12:11 PM
  3. [SOLVED] BYROW(...LAMBDA(...) ) result in #CALC! error
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-18-2022, 07:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1