Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Index of the look-alike

Latest post Fri, May 30 2008 5:45 AM by kaak. 5 replies.
  • Fri, May 30 2008 2:53 AM

    • kaak
    • Top 25 Contributor
    • Joined on Fri, Jan 18 2008
    • Edam, Netherlands
    • Posts 30
    • Points 545

    Index of the look-alike

     Hi,

    I need a combination of workshetfunctions witch gives me the index of the look-alike (exact match)...?

    Example:

    John 0
    Jelle 0
    Jeroen 0
    Bob 0
    kaak 8
    Nick 0
    Rob 0
    kaak 5

    can this be done....?

    • Post Points: 21
  • Fri, May 30 2008 4:35 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 242
    • Points 4,017
    • MVP

    Re: Index of the look-alike

    Glad to have made the list Wink

    It's not an answer for you yet, but another question. What would be the case if there were a thrird kaak, or will there never be?

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK

    • Post Points: 21
  • Fri, May 30 2008 4:45 AM In reply to

    • kaak
    • Top 25 Contributor
    • Joined on Fri, Jan 18 2008
    • Edam, Netherlands
    • Posts 30
    • Points 545

    Re: Index of the look-alike

     Nick,

    There will never be a third kaak...........

    p.s. you don't know what kinda list it is.....Stick out tongue

    • Post Points: 21
  • Fri, May 30 2008 5:22 AM In reply to

    Re: Index of the look-alike

    I'm on it too; should I be glad or scared? Surprise

     

    =MIN(IF(($A$1:$A$8=A1)*(ROW($A$1:$A$8)<>ROW(A1)),ROW($A$1:$A$8)))

    Regards

    Bob

    • Post Points: 37
  • Fri, May 30 2008 5:44 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 242
    • Points 4,017
    • MVP

    Re: Index of the look-alike

    I was working on the 'no such thing as bad publicity' type of list.

    Hope Bob's formula gives you what you want?

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK

    • Post Points: 5
  • Fri, May 30 2008 5:45 AM In reply to

    • kaak
    • Top 25 Contributor
    • Joined on Fri, Jan 18 2008
    • Edam, Netherlands
    • Posts 30
    • Points 545

    Re: Index of the look-alike

     considering your answer is correct you have nothing to fear Bob

    I owe you one

    thnx (both)

     

    • Post Points: 5
Page 1 of 1 (6 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.