Results 1 to 6 of 6

Thread: Dynamically locate and copy last number in a column before #N/A error

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-22-2023, 06:30 AM #6
    georgiboy
    georgiboy is offline
    Administrator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,308
    Location
    See attached and below for some Excel 365 options if you have 365?

    Get whole row:
    PHP Code:
    =LET(data,A2:F25,i,MIN(IFERROR(BYCOL(data,LAMBDA(x,MATCH(TRUE,ISNA(x),0))),""))-1,DROP(TAKE(data,i),i-1)) 
    Get only column E value:
    PHP Code:
    =INDEX(LET(data,A2:F25,i,MIN(IFERROR(BYCOL(data,LAMBDA(x,MATCH(TRUE,ISNA(x),0))),""))-1,DROP(TAKE(data,i),i-1)),,5) 
    OR:
    PHP Code:
    =LET(f,FILTER(E2:E25,NOT(ISNA(E2:E25))),DROP(f,ROWS(f)-1)) 
    Attached Files Attached Files
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved
    Click here for a guide on how to upload a file with your post

    Excel 365, Version 2408, Build 17928.20080
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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