Forum Discussion

jaolvera's avatar
jaolvera
Brass Contributor
Jul 14, 2023
Solved

Formula assistance

Hello, 

I was wondering if there was formula I could use that would essentially list out any person where the calREDIE DI# column is blank (Column Au would blank), and fill each row (Photo below that ) by last name first name and date of birth in each cell combined. example " Doe, John 7/7/1924"

 

 

Formulas and Functions
  • flexyourdata's avatar
    flexyourdata
    Jul 18, 2023

    jaolvera 

     

    Yes, edit the second argument to FILTER:

     

    =LET(
    missing, FILTER(Linelist!B2:D4, (Linelist!AU2:AU4 = "")*(LineList!B2:B4<>"")),
    TAKE(missing, , 1) & ", " & CHOOSECOLS(missing, 2) & " " &
        TEXT(TAKE(missing, , -1), "mm/dd/yyyy")
)
    • jaolvera's avatar
      jaolvera
      Brass Contributor
      Jul 17, 2023
      flexyourdata I tried applying the formula that you used on my last question with this one, since its the same scenario but I couldnt get it to work, ar you able to assist?
      • flexyourdata's avatar
        flexyourdata
        Iron Contributor
        Jul 17, 2023

        jaolvera 

         

        Try a variant of this (adjust the ranges):

         

        =LET(
    missing, FILTER(B2:D5, AU2:AU5 = ""),
    TAKE(missing, , 1) & ", " & CHOOSECOLS(missing, 2) & " " &
        TEXT(TAKE(missing, , -1), "mm/dd/yyyy")
)

Resources