I'm using textjoin & filter functions to get the dates when an account appears in the report. Output dates are in number format, but I need it in dd-mmm-yy format. I have done the formatting in dd-mmm-yy format, but still the output is in numbers (stored as text?). Any suggestions to fix this?
Formula in column F -
Note:
Data shown below is for illustration purpose only. Actual data runs into tens of thousands of rows & huge range of dates, accounts & other details.
Column F is formatted in dd-mmm-yy format.
(For some reason, XL2BB is not working. When I select the cells & click on mini sheet, I get a confirmation message saying that mini sheet is copied to clipboard successfully. But, when I paste in the post, nothing is getting pasted. Tried this several times, but didn't work. Hence, pasting the image & formula.)
Formula in column F -
Excel Formula:
=TEXTJOIN(",",TRUE,FILTER($B$3:$B$18,$C$3:$C$18=$E5))
Note:
Data shown below is for illustration purpose only. Actual data runs into tens of thousands of rows & huge range of dates, accounts & other details.
Column F is formatted in dd-mmm-yy format.
(For some reason, XL2BB is not working. When I select the cells & click on mini sheet, I get a confirmation message saying that mini sheet is copied to clipboard successfully. But, when I paste in the post, nothing is getting pasted. Tried this several times, but didn't work. Hence, pasting the image & formula.)