1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extracting all the data points that start with a same name

Discussion in 'Ask an Excel Question' started by Sudhakar Vashist, May 19, 2017.

  1. Sudhakar Vashist

    Sudhakar Vashist New Member

    Messages:
    6
    I want to extract all the data points from a list which starts with a same name.

    Attached Files:

  2. PCosta87

    PCosta87 Well-Known Member

    Messages:
    870
    Hi,

    Something like this perhaps (see attached).
    It will return a unique list, i.e., no duplicates.

    Hope this helps.

    Attached Files:

  3. John Jairo V

    John Jairo V Well-Known Member

    Messages:
    355
    Hi @Sudhakar Vashist (and @PCosta87).

    @PCosta87: Your formula not work if the data not appears in order. Please see attached with another option with distinct list. Blessings!

    Attached Files:

    Thomas Kuriakose likes this.
  4. PCosta87

    PCosta87 Well-Known Member

    Messages:
    870
    Hi,

    I'm not sure what you mean... it works independently of how the source data is sorted, at least in my PC.

    Can you please double check?
    Thanks
  5. John Jairo V

    John Jairo V Well-Known Member

    Messages:
    355
    Please check the file with the comparison. Blessings!

    Attached Files:

    Thomas Kuriakose and PCosta87 like this.
  6. PCosta87

    PCosta87 Well-Known Member

    Messages:
    870
    I see,

    You are 100% correct, never noticed that :(
    Thanks for pointing it out and fixing it as well :)

Share This Page