I'm enclosing a workbook with sample data. I just need help to modify CONCATENATE formula defined in cells D15:I15. or suggest a new formula to achieve the desired result i.e. the returns despatch no based on date, if on a particular day there is only one dispatch no it gives one but if on a particular day there are more than one dispatch no's it shows all of them by separating by & sign.
Last edited by leo73pk; 12-19-2020 at 03:57 AM. Reason: solved
Best Regards,
Hamza
It is the greatest of all mistakes to do nothing because you can only do little - do what you can.
If you're really using Microsoft 365, so Office 365, you should have TEXTJOIN, FILTER and UNIQUE functions. If so, try
D15:
Formula:
Please Login or Register to view this content.
If you're not using Office 365, what version are you using?
Last edited by hrlngrv; 12-19-2020 at 02:36 AM. Reason: correction -- adding 3rd arg to FILTER
Thanks hrlngrv
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks