I'm currently working on a user list that says what applications they have installed. I wish to align the values like you would here: https://excelribbon.tips.net/T008316_Synchronizing_Lists.html
It uses this formula, =IF(ISNA(VLOOKUP(A2,F:G,2,FALSE)),0,VLOOKUP(A2,F:G,2,FALSE))
which only aligns if the two master columns that match together align well.
However, there are some duplicates in the list, and I would like those duplicates to go into the same cell. Let me give you an example.
What I have:
What I would like to do, is that those apps all appear next to the user's name in one cell, like so.
Would this be possible, through some godly formula?
Its a 300 row file that I might have to do again sometime, so I would rather not do it manually.
View best response
If you have Excel 365, you may use the TEXTJOIN() function.
See example here:
Hope this helps!PReagan
@PReagan This is exactly what I needed, thank you so much.