=TEXTJOIN(",",TRUE,IF($D$2:$I$87=M2,$A$2:$A$87,""))
The information being pulled is Dates,
unfortunately it keeps pulling the dates as Numbers ,
I have tried the Text and “dd/mm/yyyy” but im not sure where to put it into the formula,
ive tried a couple of locations , but i just get you have entered too many Arguments for this Function or Value ,
I assume its because its pulling too Many Dates and the Formula doesnt know how to figure out the multiple dates,
which if i go to a cell with only one Value and test in an adjoining Cell
=TEXT(P2,"dd/mm/yyyy")
if there is only one Value in P2 it will give a correct Date ,
if there are Multiple Values it just gives a #Value Error
Any Help Appreciated
