Need help making a list in excel

  • Hello,


    I have a list (list 1) with 100+ names of companies, many of them repeating. I am trying to make a new list (list 2) that has each of the companies in list 1 just listed once in list 2. And in list 2 it will automatically add any new companies that are put into list 1 into list 2.


    I have made an example below:



    List 1:



    [TABLE="width: 500"]

    [tr]


    [td]

    Type of Food

    [/td]


    [td]

    Person its from

    [/td]


    [td]

    Amount

    [/td]


    [/tr]


    [tr]


    [td]

    Apples

    [/td]


    [td]

    betty

    [/td]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td]

    Apples

    [/td]


    [td]

    george

    [/td]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    Oranges

    [/td]


    [td]

    cassie

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    Burger

    [/td]


    [td]

    lucy

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    Fries

    [/td]


    [td]

    matt

    [/td]


    [td]

    3

    [/td]


    [/tr]


    [/TABLE]



    -List 1 has the breakdown of the Types of foods (company) and the amount of each that the person has.


    List 2:



    [TABLE="width: 500"]

    [tr]


    [td]

    Food

    [/td]


    [td]

    Amount

    [/td]


    [/tr]


    [tr]


    [td]

    Apples

    [/td]


    [td]

    7

    [/td]


    [/tr]


    [tr]


    [td]

    Oranges

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    Burgers

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    Fries

    [/td]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]


    -List 2 is suppose to take the type of food in list 1, display it once and add any new foods that are currently not in list 2.


    Issue:
    -If I add a new food into list 1 like pasta, what formula do I use in list 2 to make it show up ? I understand how to do the amount column for list 2. I am just really confused on how to do the food column for list 2

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!