Forum Discussion
Dates of visits from table based on the crtieria
Multiple dates of visit can be returned in a single cell using the TEXTJOIN function. This formula is available in recent versions of Excel. In the screenshot is TEXTVERKETTEN which is the name of TEXTJOIN in german Excel. The formula is translated when you open the attached sample file.
OliverScheurich
Hi, thanks for the reply.
I cannot get what u did in the attachment.
I have prepared some sample data.
Kindly review it and see if you can help.
sorry, it did not let me attach xlsx file
Multiple dates of visit can be returned in a single cell using the TEXTJOIN function. This formula is available in recent versions of Excel. In the screenshot is TEXTVERKETTEN which is the name of TEXTJOIN in german Excel. The formula is translated when you open the attached sample file.
- Thanks mate. this is exactly what I was trying to do.