Forum Discussion
Solved
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 ...
Please refer to the attached with a workaround in case you don't have access to the TEXTJOIN function.
Since you didn't provide a sample workbook, I prepared one with a slightly different layout and used the following Array Formula which requires confirmation with Ctrl+Shift+Enter to get the multiple occurrences of EFC Codes if any.
=TEXTJOIN(", ",TRUE,IF($B$2:$B$23=LARGE(IF(FREQUENCY($B$2:$B$23,$B$2:$B$23),$B$2:$B$23),D2),$A$2:$A$23,""))
- 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?
Please refer to the attached with a workaround in case you don't have access to the TEXTJOIN function.
- Thank you very Much!! that is perfect
