I am returning multiple values, using CHAR(10) to have the items show up on multiple rows and excluding duplicate values. Everything is working but I want to get the dates to get returned in a date format. I have found a simpler formula to achieve this but have been unsuccessful on replicating in my formula. Any thoughts on how to make this work?
Thanks
Example Formula
=TEXTJOIN(", ", TRUE, IF(M7=I2:I2000,TEXT(C2:C2000,"mm/dd/yyyy"),""))
My Formula
=TEXTJOIN(CHAR(10), TRUE, IF(IFERROR(MATCH(Open_Pred_Pred_WOs[Date Created], IF([@[WO Asset Number]]=Open_Pred_Pred_WOs[Reporting Asset], Open_Pred_Pred_WOs[Date Created], ""), 0),"")=MATCH(ROW(Open_Pred_Pred_WOs[Date Created]), ROW(Open_Pred_Pred_WOs[Date Created])), Open_Pred_Pred_WOs[Date Created], ""))
Thanks
Example Formula
=TEXTJOIN(", ", TRUE, IF(M7=I2:I2000,TEXT(C2:C2000,"mm/dd/yyyy"),""))
My Formula
=TEXTJOIN(CHAR(10), TRUE, IF(IFERROR(MATCH(Open_Pred_Pred_WOs[Date Created], IF([@[WO Asset Number]]=Open_Pred_Pred_WOs[Reporting Asset], Open_Pred_Pred_WOs[Date Created], ""), 0),"")=MATCH(ROW(Open_Pred_Pred_WOs[Date Created]), ROW(Open_Pred_Pred_WOs[Date Created])), Open_Pred_Pred_WOs[Date Created], ""))