Forum Discussion

Anonymous's avatar
Anonymous
Jul 18, 2019
Solved

Align Columns with Duplicates

Hi there!   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_...
Formulas and Functions
  • PReagan's avatar
    PReagan
    Jul 18, 2019

    Hello Deleted,

     

    If you have Excel 365, you may use the TEXTJOIN() function.

     

    See example here:

    https://chandoo.org/wp/vlookup-multiple-matches-trick/ 

     

    Hope this helps!
    PReagan

PReagan's avatar
PReagan
Bronze Contributor
Jul 18, 2019

Hello Deleted,

 

If you have Excel 365, you may use the TEXTJOIN() function.

 

See example here:

https://chandoo.org/wp/vlookup-multiple-matches-trick/ 

 

Hope this helps!
PReagan

Anonymous's avatar
Anonymous
Jul 18, 2019

PReagan This is exactly what I needed, thank you so much.

Resources