mercredi 15 juin 2016

Excel - Modal value in list with IF function

I want to find the most common value in a list, matching the most common outcome by name.

I know it revolves around an index with mode and match function, with an IF function in there. But can't get it down.

Raw Data

USER NAME       Items
James Ile       Flat White 
James Ile       Flat White 
Michael Pane    Latte 
Lily Wilk       Iced Drinks 
Louise Coset    Millionaire Shortbread 
Louise Wyli     Flat White 
Louise Wyli     Millionaire Shortbread 
Louise Wyli     English Breakfast 
Louise Cosett   Cheese Toastie 
Louise Wyli     Flat White
Louise Cosett   Pineapple Sunset 
James Court     Espresso 

Desired Result

USER    
James Ile        Flat white
Michael Pane     Latte
Lily Wilk        Iced Drinks
Louise Cosett    Cheese Toastie
Louise Wyli      Flat white
James Court      Espresso

Aucun commentaire:

Enregistrer un commentaire