Forum Discussion
Natas20075
Jun 17, 2020Copper Contributor
show the 2nd data with same value
Hi, I need to found a way that will look the columns where the number of time appear and show the name of that EFC. most of the time, we can have the same number for different EFC code and I need to ...
- Jun 17, 2020
Please refer to the attached with a workaround in case you don't have access to the TEXTJOIN function.
Natas20075
Jun 17, 2020Copper Contributor
thank you for that quick response, I forget something important, I have the Excel 2013, unfortunately I don't have the nice new futur like "TextJoin", how I can do the same with my version?
Subodh_Tiwari_sktneer
Jun 17, 2020Silver Contributor
Please refer to the attached with a workaround in case you don't have access to the TEXTJOIN function.
- Natas20075Jun 17, 2020Copper ContributorThank you very Much!! that is perfect
- Subodh_Tiwari_sktneerJun 17, 2020Silver Contributor
You're welcome Natas20075! Glad it worked as desired.