Groups

    Excel HELP!!

    Good Morning

    I am trying to use the functionality as descriped in the below link:

    office.microsoft.com/en-…spx

    I have copied the data exactly from the example table and the formula from the website but I receive a #Ref error in cell B10 when I get to the following point:

    Return corresponding values from column B

    Forumla

    =INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1 :$A$7)),ROW(2:2)))

    Any help is much appreciated.

    5 Comments

    Banned

    This Web page is unavailable

    Banned

    Need to send us the link again.

    Edit - I think I found it. ]http//of…spx

    Also - use B9 instead of B10.

    Banned

    =index($a$1:$b$7,small(if($a$1:$a$7=$a$9,row($a$1:$a$7)),row(1:1)),2)

    Original Poster

    Great! Thanks Alot every1

    Rep added
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Are these two things distinctly different to you?32156
      2. Surprise! The HUKD Summer Flamedeer Hunt 2017 **OFFICIAL THREAD** (trading …188498
      3. 'Hard' Brexit offers '£135bn annual boost' to economy - BBC News1949
      4. Anyone else find Playerunknown super addictive but soooo frustrating54

      See more discussions