Results 1 to 19 of 19

Recursive lambda

Threaded View

Glenn Kennedy Recursive lambda 02-11-2024, 12:34 PM
HansDouwe Re: Recursive lambda 02-11-2024, 02:29 PM
HansDouwe Re: Recursive lambda 02-11-2024, 03:02 PM
HansDouwe Re: Recursive lambda 02-12-2024, 03:42 AM
DJunqueira Re: Recursive lambda 02-12-2024, 01:54 PM
Glenn Kennedy Re: Recursive lambda 02-12-2024, 01:11 PM
HansDouwe Re: Recursive lambda 02-13-2024, 05:52 AM
Glenn Kennedy Re: Recursive lambda 02-12-2024, 01:13 PM
Glenn Kennedy Re: Recursive lambda 02-12-2024, 02:05 PM
romperstomper Re: Recursive lambda 02-12-2024, 07:31 PM
HansDouwe Re: Recursive lambda 02-13-2024, 05:25 AM
John Vergara Re: Recursive lambda 02-12-2024, 10:26 PM
HansDouwe Re: Recursive lambda 02-13-2024, 05:28 AM
John Vergara Re: Recursive lambda 02-13-2024, 10:47 AM
HansDouwe Re: Recursive lambda 02-13-2024, 11:16 AM
romperstomper Re: Recursive lambda 02-13-2024, 05:31 AM
AliGW Re: Recursive lambda 02-13-2024, 11:43 AM
romperstomper Re: Recursive lambda 02-13-2024, 11:49 AM
AliGW Re: Recursive lambda 02-13-2024, 11:51 AM
  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Recursive lambda

    JeteMc answered the original Q. GregB11 made the first O365-type formula:

    https://www.excelforum.com/excel-for...ml#post5919354



    I took it to the next stage. However, as I said in the thread, my brain only works in straight lines. I can't do recursive lambdas. The original post referred to thousands of staff memebrs and 15 reporting levels. Can anyone out there see how to calculate the number of direct and indirect reportees under each staff member with a recursive lambda, or similar, thus avoiding the need for 15 of these????

    Level2,FILTER(a,ISNUMBER(MATCH(b,Level1,0)),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match and Extract -LAMBDA,MAP,FILTER
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 02-02-2024, 04:55 AM
  2. Need help getting LAMBDA to work
    By Newtonus_Prime in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-21-2023, 09:15 AM
  3. [SOLVED] Using TEXTSPLIT with MAP and LAMBDA is not working
    By Jacc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2023, 03:15 PM
  4. [SOLVED] Bisectional method using recursive Lambda
    By Jacc in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-07-2023, 05:19 PM
  5. [SOLVED] Maximum Drawdown and LAMBDA
    By andrewc in forum Excel General
    Replies: 5
    Last Post: 06-28-2023, 09:25 AM
  6. [SOLVED] LAMBDA iteration
    By Slabu in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-20-2021, 08:39 PM
  7. Lambda Expressions in Excel VBA
    By Gregor y in forum Tips and Tutorials
    Replies: 4
    Last Post: 10-17-2014, 06:59 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1