Consulting

Results 1 to 2 of 2

Thread: Dealing with Ties when using Vlookup with Rank.

  1. 11-16-2007, 10:07 AM #1
    Sir Babydum GBE
    Sir Babydum GBE is offline
    VBAX Mentor Sir Babydum GBE's Avatar
    Joined
    Mar 2005
    Location
    Cardiff, UK
    Posts
    499
    Location

    Dealing with Ties when using Vlookup with Rank.

    Hi

    How to I get a vlookup that is looking at a ranking column to return the top 10 performers if there is a tie?

    For example, if there are two joint winners, then there'll be no rank "2" - so my Vlookup that looks for rank "2" will return #N/A. Then my list of top 10 performers will be missing one of the joint leaders.

    Help!

    Thanks

    BD
    Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
    Reply With Quote Reply With Quote
  2. 11-16-2007, 10:18 AM #2
    Sir Babydum GBE
    Sir Babydum GBE is offline
    VBAX Mentor Sir Babydum GBE's Avatar
    Joined
    Mar 2005
    Location
    Cardiff, UK
    Posts
    499
    Location
    Ok thanks to anyone that was dealing with this - but I found the answer here: http://www.cpearson.com/excel/Rank.aspx

    Thanks again
    Have a profound problem? Need a ridiculous solution? Post a question in Babydum's forum
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules