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 tha...
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")
)