M Mehmud Khan Member Feb 9, 2023 #1 Dear Friends, Need your valuable assistance. somebody can please help me in attached query. Thanks in advance. MK Attachments example file.xlsx 8.4 KB · Views: 3
Dear Friends, Need your valuable assistance. somebody can please help me in attached query. Thanks in advance. MK
M Mehmud Khan Member Feb 9, 2023 #3 thanks you so much for your reply bosco.... 1 preference to formula... in case any difficulties in formula then VBA..
thanks you so much for your reply bosco.... 1 preference to formula... in case any difficulties in formula then VBA..
B bosco_yip Excel Ninja Feb 9, 2023 #4 Try, [D2]: =TEXTJOIN(" | ",,IF(A$2:A$12=A2,B$2:B$12,"")) Formula copied down.
M Mehmud Khan Member Feb 9, 2023 #5 Thanks for your quick reply bosco... really appreciable.. unfortunately I am getting below error; did I missed anything...!
Thanks for your quick reply bosco... really appreciable.. unfortunately I am getting below error; did I missed anything...!
B bosco_yip Excel Ninja Feb 9, 2023 #6 Mehmud Khan said: Thanks for your quick reply bosco... really appreciable.. unfortunately I am getting below error; did I missed anything...! View attachment 82915 Click to expand... Maybe you don't have Textjoin function in your Excel. Textjoin function only available in Excel 2019, Excel 2021 and O365. And, if you still wanted to use formula, please download a Textjoin UDF by Google searching machine. Note: Without Textjoin function, it will become a lo.......ng formula. So that, you better open a new post and forwards your question to our VBA forum. Thank you. Last edited: Feb 9, 2023
Mehmud Khan said: Thanks for your quick reply bosco... really appreciable.. unfortunately I am getting below error; did I missed anything...! View attachment 82915 Click to expand... Maybe you don't have Textjoin function in your Excel. Textjoin function only available in Excel 2019, Excel 2021 and O365. And, if you still wanted to use formula, please download a Textjoin UDF by Google searching machine. Note: Without Textjoin function, it will become a lo.......ng formula. So that, you better open a new post and forwards your question to our VBA forum. Thank you.
M Mehmud Khan Member Feb 9, 2023 #7 Thanks you so much bosco.... due to office restrictions not be able to download that function... would be more thanksful if you make small VBA... thanksful for your every valuable seconds...
Thanks you so much bosco.... due to office restrictions not be able to download that function... would be more thanksful if you make small VBA... thanksful for your every valuable seconds...
V vletm Excel Ninja Feb 9, 2023 #8 Mehmud Khan As bosco_yip wrote So that, you better open a new post and forwards your question to our VBA forum.
Mehmud Khan As bosco_yip wrote So that, you better open a new post and forwards your question to our VBA forum.