1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need Tool / Script / Excel Script To Sort Lists of Keywords

Discussion in 'Programming' started by apex1, Sep 7, 2016.

  1. apex1

    apex1 Junior Member

    Joined:
    May 29, 2015
    Messages:
    112
    Likes Received:
    97
    I want to input multiple lists of keywords and have them sorted for me:

    List 1:

    Audi
    Mercedes
    Jaguar

    List 2:

    Audi
    Ferrari
    Lamborghini

    Output:

    Audi (2)
    Mercedes
    Jaguar
    Ferrari
    Lamborghini

    As you can see in the output if the lists have any duplicate keywords it will add a count (2) each list will keep adding new keywords and stacking the count if there are any duplicates.

    How can I do this?
     
  2. ekapek

    ekapek Jr. VIP Jr. VIP Premium Member

    Joined:
    Aug 2, 2010
    Messages:
    266
    Likes Received:
    47
    Home Page:
    You can use mysql with query insert ignore on duplicate key update counter=counter+1

    Or in excel use: =SUMPRODUCT((A1:A100<>"")/COUNTIF(A1:A100,A1:A100&"")) than sort by counter and remove duplicates