SOLVED
Home

Align Columns with Duplicates

Deleted
Not applicable

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_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:

John   John App #1
Jane   John App #2
Tom  Jane App #1
Rob  RobApp #1
Etc.  RobApp #3
Etc.  RobApp #4

What I would like to do, is that those apps all appear next to the user's name in one cell, like so.

John App #1, App #2 John App #1
Jane App #1 John App #2
RobApp #1, App #3, App #4 Jane App #1
Etc.  RobApp #1
Etc.  RobApp #3
Etc.  RobApp #4

 

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.

 

Thanks,

Andre

2 Replies
Solution

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 This is exactly what I needed, thank you so much.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies