Forum Discussion
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...
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 If you have Excel365 you could try something like this:
=BYROW(FILTER(B2:D5,AU2:AU5<>""),LAMBDA(a,TEXTJOIN(",",,a)))
- 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?
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") )jaolvera Do you have Excel365? Can you upload/share a file?
- I added the attachment
so workbook 1 is where the formula would go and the cells its refrencing would be "linelist" workbook.
the formula you provided I have already in the workbook when you click on the cell
