+ Reply to Thread
Results 1 to 6 of 6

Rank several criteria

  1. #1
    Registered User
    Join Date
    02-06-2011
    Location
    Tel aviv, Israel
    MS-Off Ver
    Excel 2013
    Posts
    59

    Rank several criteria

    Hi there,

    i attached a demo file
    i have a large database which i need to sort per several Criteria - i tried many ways, and i only solved it with much complexity.
    i have a list (on the left- in the file) for which i have site name, different keyword, the date, and the rank.

    in the table on the right i need to sort the data per key word and date... and to show the 3 top ranking sites and their actual ranking.
    of course i need to add the Key-word and date first (in a formula) and then to rank the sites.
    another issue - i need to show only the top 3 and to ignore the rest of the data.

    of course if you find a simple solution and needs to arrange the table on the right differently, be my guest.

    i tried so many things and it just killed me.

    thank you in advanced.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Rank several criteria

    can VBA be used?

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,449

    Re: Rank several criteria

    Hi atlant15,

    I really don't understand what you want, but this looks like a Pivot Table with a top 3 filter to me, kind of answer. See
    http://www.contextures.com/excel-piv...ers-top10.html
    for some examples of what I mean. You might need bottom instead of top if you want rank 1, 2, 3.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Re: Rank several criteria

    Check this out. Hope this would suffice.

    Cheers
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-06-2011
    Location
    Tel aviv, Israel
    MS-Off Ver
    Excel 2013
    Posts
    59

    Re: Rank several criteria

    thank you all,
    VBA is not an option - its for someone in the company who barely uses excel and i don't understand it very well.

    the last solution is wonderful - thank you Mysore.

  6. #6
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Re: Rank several criteria

    No worries. Please mark the thread as solved and click on reputation if you wish to.
    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rank with 2 criteria
    By huy_le in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-06-2014, 05:48 PM
  2. Rank on two different criteria
    By Johnmus in forum Excel General
    Replies: 4
    Last Post: 12-09-2012, 05:47 AM
  3. Rank by Certain Criteria
    By mini_cam in forum Excel General
    Replies: 3
    Last Post: 09-25-2011, 05:42 AM
  4. Rank using Criteria
    By sinspawn56 in forum Excel General
    Replies: 2
    Last Post: 03-10-2011, 02:59 AM
  5. To Rank on two Criteria
    By tckok56 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-08-2006, 05:23 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1