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.

Need Help with Index Formula

Discussion in 'Ask an Excel Question' started by mu4you, Oct 11, 2017 at 10:20 AM.

  1. mu4you

    mu4you New Member

    Messages:
    16
    Dear Sir,

    I want to get the duplicate values, sample attached.

    Attached Files:

  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,586
    Hi ,

    See the attached file.

    Narayan

    Attached Files:

    Naresh Yadav likes this.
  3. Naresh Yadav

    Naresh Yadav Active Member

    Messages:
    146
    Hi,

    Pls try this one

    =INDEX($B$1:$B$5,AGGREGATE(15,6,ROW($A$1:$A$5)/($A$1:$A$5=C1),COUNTIF($C$1:C1,C1)))

    Attached Files:

  4. mu4you

    mu4you New Member

    Messages:
    16
    Great !!!! thanks a lot Naresh & Narayank....

Share This Page