Hello all Experts
I have two coloumns one with a lot of names and another one with some breakfast consumptions.
It could look like this
Coloum 1: Column 2:
Thor Banana
Anna Frosties
Martin Bun
Peter Banana
Martin Bun
Thor Bun
Anna Frosties
Peter Banana
Anna Bun
Martin Banana
Thor Bun
Peter: Bun
I would like to make a function that for each name calculates the most common string for that name and returns it.
But I have no idea how to start
Thank you for your help!
Bookmarks